ONe way would be to just save a copy of the file under a new name....then
change whatever data is required......

Vaya con Dios,
Chuck, CABGx3


"nickclingan"
wrote in message
...

Hello,

I have been asked to create a worksheet in which there is some sort of
button/condition that can be selected which will then copy all of the
information in the worksheet to another specified worksheet in another
workbook. Basically it needs to be a test worksheet template in which
the user can make some sort of selection to have all the information
logged into the sheet copied over to a subsequent worksheet without
having to go through copying/pasting or resaving by themselves. Is
there any way to do this? Thanks,

Nick


--
nickclingan
------------------------------------------------------------------------
nickclingan's Profile:
http://www.excelforum.com/member.php...o&userid=28623
View this thread: http://www.excelforum.com/showthread...hreadid=495680