Hello,
I have two columns. Col A may have blank cells. I have a code which copies and pastes all data (minus blank cells) from Col A (from A2:A19) to the first blank cell of Column H. However, what I require is to only copy and paste those cells in Col A, whose adjacent cells in Col B are not blank. Right now, it's pasting all the data between rows 2 and 19 in Col A (minus any blank cells in col A) to Column H. I have no idea how to manipulate it to only paste those cells whose adjacent cell in col B is not blank. As I am new to VBA, any help is greatly appreciated!
Bookmarks