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

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

Hi Ron
What im looking for is a way to data from several cells to another
workbook. I have put together a HGV Time sheet that records all
delivery and collection details, Hours worked and POA. I put something
similar together about 2 years ago but over the year companys need more
information so this new one does this, but rather than put all the week
together I have split them into seperate weeks (workbooks). Each
workbook has a week start and end date, week number plus a couple of
other cells I need to transfer. I need to be able to transfer the end
date cell from 1 workbook to the start date of the next workbook even
though the workbook is not open, can this be done????


--
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

Hi Chris

You can add a link to the other workbook ?

='C:\Documents and Settings\Ron\My Documents\[Book1.xls]Sheet1'!$A$1

It is also possible to create the links or copy the values with code
What are the names of the workbooks ?


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


"Chris Watson" wrote in message
news:Chris.Watson.23g470_1140300919.2882@excelforu m-nospam.com...

Hi Ron
What im looking for is a way to data from several cells to another
workbook. I have put together a HGV Time sheet that records all
delivery and collection details, Hours worked and POA. I put something
similar together about 2 years ago but over the year companys need more
information so this new one does this, but rather than put all the week
together I have split them into seperate weeks (workbooks). Each
workbook has a week start and end date, week number plus a couple of
other cells I need to transfer. I need to be able to transfer the end
date cell from 1 workbook to the start date of the next workbook even
though the workbook is not open, can this be done????


--
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

Hi Ron
The Link you surggested work fine, it transfer the data I need.
Thanks Ron for all your help.

Regards Chris


--
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

Hi Ron
Ive just come across and slight problem, If add the links as you
surggested it will only work on my computer because of the file
refereance, is there a formula or anyway to transfer data another
way??????


--
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

Hi Rob
I have managed to make it work, If I keep all the weeks.xls in 1
folder, I can Link each cell by putting in:

=[Week 1.xls]Sheet1!E5

This works fine, so I can put the whole file onto another computer and
everything works.

Once again thank you Ron.


--
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