Bigyan Bhandari

1

votes
3

answer
61

views

Excel VBA - How to do Loop for Copying Data following blank cells in a column and paste it to last empty column?

I am working on a spreadsheet where I need to copy a block of data in column A (which are in between blank spaces) and paste it to last empty column. Example: I have data in range A1:A18 and a blank cell, and again data in A20:A37 and 2 blank cells & and again data in A40:A57 & so on. I need to copy...
Bigyan Bhandari
1

votes
1

answer
0

views

Excel VBA - Select cells containing specific texts in Specified row and shift cells down

I am new to Excel VBA, I tried creating a code searching through different forums, which will select the cells that contain 'NNN', 'MG','FS','N','IG' etc text strings in Row 7 and Shift those cells down. But I got stuck in middle and got an error, also I didn't get the idea how to use multiple crite...
Bigyan Bhandari