Data Transfer?????

[Chris Watson]

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

 

[Ron de Bruin]

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

 

[Chris Watson]

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

 

[Ron de Bruin]

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 ?

 

[Chris Watson]

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

Regards Chris

 

[Chris Watson]

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]

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.