See Ron de Bruin's site
http://www.rondebruin.nl/tips.htm
Browse through the section on Copy/Paste/Merge examples
Gord Dibben MS Excel MVP
On Sun, 7 Oct 2007 10:07:00 -0700, FARAZ QURESHI
wrote:
Hi Guys,
Can you devise a macro that when I open two workbooks of similar structure,
one with the macro, and run the macro the data on the other opened sheet is
copied and pasted on the macro containing book.
Next time I run the same code the data is again copied from the other sheet
and pasted on the macro possessing workbook but in the end, i.e. after
non-blank rows.
Thanks in advance