Hi madcat

Try one of the examples on this page
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"madcat " wrote in message ...
I have a multiple data sheets. There are data in row 1

I need the data in row 1 to be copied over but there are so many row 1
in different sheets. How can i copy all row 1 over i.e sheet2 row 1
would be in row 2 since row 1 is occupied?


---
Message posted from http://www.ExcelForum.com/