Transferring data from one workbook to anothe

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month