Forum Discussion
Help!!!!
cuong This is what I am working on. All I want to do is be able to copy the data from sheet to sheet while changing the dates on said sheets without having to do each date individually?
Is this possible I am sure it is but I look like a dumb **bleep** to my boss right
now
You may define end of the week date in E1, under Sunday =E1, under Sat =T4-1, etc.
Thus copy/pasting the sheet you need only change the date in E1. Not sure about time and other data As for the sum under Monday current formula is
=SUM('P:\OutlookAttachments\[Wabash Manpower Schedule.xlsx]3-7-21'!A1)You may change it with INDIRECT adjusting the path to the value in E1, but that requires that referenced file shall be opened. Perhaps that's not the case (not sure why do you need SUM for only one cell). The solution could be to generate formulas as above for all 54 weeks of the year in additional sheet which could be hided if necessary, and take results from these set of values. Possible errors for the future weeks could be handled by =IFERROR(..., "").