Hi There!
I have two spreadsheets with several rows of data on each of them, they
both have header rows, with the same heading names. I want to copy the
data from spreadsheet 1 ( without the header row) to the spreadsheet 2
but keeping spreadsheet 2 original data ( i.e NOT REPLACE ) i just want
the data on spreadsheet 1 to be pasted on after the last line of data
on spreadsheet 2; as i need to keep the existing data in spreadsheet 2.
Any ideas on how I can do this with a macro or VB code?
Help appreciated thanks!
Gord Dibben - 11 Jan 2006 18:13 GMT
See Ron de Bruin's site for various copying macros.
http://www.rondebruin.nl/copy1.htm
Gord Dibben MS Excel MVP
>Hi There!
>
[quoted text clipped - 7 lines]
>
>Help appreciated thanks!
mellowe - 12 Jan 2006 14:24 GMT
Brilliant recommendation! Thanks V. much!!! Was very helpful.