insert copied data from sheet1 to sheet2

[prabhuduraraj09]

Hi all,

I have data in sheet1, which needs copied to sheet2

But in sheet2 already data is available.
In Sheet2, i want code to go from header to down , to locate the first blank row in between data
and to paste data by inserting same number of rows as number of rows copied.

Attached example file for reference.


Hope to get some help on this.....

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[prabhuduraraj09]

Hi John H. Davis,

Thanks for the help, this worked very well. i was making error in syntax.

Added some stars for you

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.