Transferring data from one workbook to anothe

Closed
Marcia - Mar 29, 2010 at 11:33 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 29, 2010 at 02:41 PM
Hello,
I have created a workbook for timesheet information on all employees. I have tabs set up for each employee. The totals get calculated in another tab. I am able to keep track of all personal, sick, and vacation time this way. However, I have a timesheet set up in an individual workbook in each persons personal folder, on our network, which the staff updates bimonthly. I'd like to know how to automatically update my workbook with the information in their workbook without having to go into each individual folder and copying and pasting the information.

Any help with this is greatly appreciated.

Marcia

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 29, 2010 at 02:41 PM
Depend on how and what. The most basic way would be have a link to those workbooks(just as you do for other sheet)'
example would be
='[Book.xls]Sheet1'!$A$1
1