Hi,
I've seen solutions to this but can't quite work out how to get mine to work just as I wish. Basically I need a macro to copy a range from one sheet to another, but the checking for an empty row in column B (before pasting) should start from B6 (as there are blank cells above that need to remain blank). Unfortunately I can't get it to work properly. The offset works the once, but then each subsequent paste leaves another 3 blank lines before pasting the info across. Any help appreciated!
The code I have is as follows:
Bookmarks