Try this
http://www.rondebruin.nl/copy2.htm

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


"GSEX " wrote in message ...
I'm trying to copy the value of a cell reference("I3")from multiple
worksheets into a summary worksheet in a relative column to each
worksheet in the next available cell using a macro.

would appreciate any help.
gs


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