How would I write a macro that would Copy the first 5 rows after an empty row...

[rjw524]

Hi Everyone,

My name is RJ and I've been a member for a long time but this is my first actual post.

What I need to do seems easy, but I just don't know enough about VBA yet to program what I need.

Basically, I have a worksheet that gets a bunch of data records dumped into it. The first problem was, the dump did not insert a blank row between each new record. But I wrote a macro to fix that.

-The data is ALWAYS in Column A of Sheet1
-Each Record consists of anywhere from 10 to 15 rows.
-The rows can go into the 20,000s...

NOW, THIS WHAT I'M TRYING TO DO:

a) I need to copy the first row of data FOLLOWING EACH EMPTY ROW I inserted to separate each record in Sheet1
b) Paste those rows into Sheet2

This seems like is should be a simple thing to do, but I can't figure the dang thing out.

Any help would be greatly appreciated!

Thanks,

RJ

[walruseggman]

Please Login or Register  to view this content.

[rjw524]

Thanks a ton, walrus!

This worked beautifully!