Sharing information between Workbooks

[rfiliaga]

I am setting up timesheets that will not only calculate the current pay period hours and benefits, but will also bring benefits already earned forward from the previous pay period.

To illustrate:

John has 50 hours of Vacation (PTO) at the end of the last pay period. His timesheet shows the 50 hours in a cell below the heading PTO Balance. The column is all the balances for PTO and the row is specific to John's information.

I want this information to move forward into the new timesheet for the next pay period so that when he uses 8 hours of vacation and earns 4.62 hours it will automatically bring the 50 hours he already has earned into that formula to give a total of 46.62 hours remaining.

My current solution is to go back to the last timesheet and get the balance from that sheet to put into the column labeled PTO Forward and then have an easy formula that is something like this: = D39 + E39 - F39. By bringing the balance forward from the other worksheet, if there were corrections made those corrections would automatically update in the new worksheet.

I hope this isn't too convoluted for an answer. Thanks!

[arlu1201]

In your New timesheet, you can directly link the cell containing the balance brought forward to the cell in the last year's timesheet that had the balance remaining at the end of the year. That way if any changes are made to last year's timesheet, it will reflect in this year's sheet as well.