May 22 2019 11:22 AM
I am setting up a roster/timesheet and linking data to clients , staff and hours. The source workbook has sheets named Wk 1 then Wk 2 Wk 3 etc. The formula in the destination workbook is =SUM(J7-'[Weekly Time sheets homemade.xlsx]Wk 2'!$W$6)+O6 then next cell down I have written =SUM(J8-'[Weekly Time sheets homemade.xlsx]Wk 3'!$W$6)+O7 As their are 52 weeks I would like to drag the formula down with the week numbers changing as well. The formula value !$W$6) needs to remain as is which it is doing. Any ideas?I am new would appreciate any help :)
May 22 2019 12:40 PM
May 23 2019 09:37 PM
I simulated your workbooks in the attached files. The formula in [Destination.xlsx]Sheet1!K6, copied down rows, is:
=J6-INDIRECT("'[Weekly Time sheets homemade.xlsx]Wk "&ROW()-5&"'!W6")+O5
I hope the foregoing formula returns your desired result. If not, please let me know.
May 23 2019 09:39 PM
The source workbook failed to attach. Here it is.