rcameron315
New Member
- Joined
- Dec 20, 2016
- Messages
- 1
HI! I am not sure if this is possible. I have a spreadsheet that has a "weekly Summary" tab. I have the following formula in cell b2: =SUMIF('Doe,John'!B2:B53,Week,'Doe, John'!L2:L53)
on the weekly summary tab I have a list of employees in column A, the formula in column B, and another cell where I type the current week. There is also a tab for each employee to report their excluded time for productivity. So its looking at each tab and gathering the total in column L for the week I input.
I have to save a new copy of this spreadsheet for 2017 and am trying to find the easiest way to copy in the formulas on this summary tab. I tried just copying the tab over (from 2016 spreadsheet) and that doesn't work. I can correct each formula manually but is there a way to correct one and copy down with the data updating to look at the next tab?
on the weekly summary tab I have a list of employees in column A, the formula in column B, and another cell where I type the current week. There is also a tab for each employee to report their excluded time for productivity. So its looking at each tab and gathering the total in column L for the week I input.
I have to save a new copy of this spreadsheet for 2017 and am trying to find the easiest way to copy in the formulas on this summary tab. I tried just copying the tab over (from 2016 spreadsheet) and that doesn't work. I can correct each formula manually but is there a way to correct one and copy down with the data updating to look at the next tab?