Hi Chris

so I have duplicated the workbook 17
You can use SaveCopyAs in a VBA macro to make copy of your workbook with a different name
If you need help post back

If you only want to change a part of the workbook see
http://www.rondebruin.nl/copy4.htm


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


"Chris Watson" wrote in message
...

I have put together a Drivers Daily Time workbook that covers 1 weeks
activities including POA, POA (Period Of Availability) by law has to be
recorded over a period of 17 weeks, so I have duplicated the workbook 17
times.What I need to do is transfer data from the first workbook to the
second and so on. Is this possible????


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=513962