how to merge data in two sheets in every next row

Hi all,

I have equal row data in 2 sheets of same work book.
Sheet1 have 1000 rows of data and sheet2 have 1000 rows of data

The expected output is to put both sheets data into 1 sheet
1row from sheet1 and 2row should be 1 row from sheet2....likewise it should continue

Now the collated sheet should have total of 2000 rows of data.

any sample code should get me started.

Try this macro. Data will be placed in Sheet3.

Please Login or Register  to view this content.