Hi all,
I use a spreadsheet to enter daily sales figures for our business. This happens every day. (Shelter Daily Report)
I Have created a second page that is designed to take some of the data required by our bookkeeper from DAILY ENTRY and show it in a weekly report. (Gaz weekly report)
I have attached an image for reference
I would like to be able to manually enter the date of the Sunday for end of week into cell A2(eg this Sunday 15/5/2022)
By doing this - I would like the table to update the Monday to Sunday dates (cells C2:I2) (Monday 9/5/2022 to Sunday 15/5/2022)
I would then like the cells C2:I2 to bring corresponding data from those dates into the fields below
If C2 becomes Monday 9/5/2022 - I would like C5 C6 C7 etc etc to pull data from the Shelter Daily report figures entered on Monday 9/5/2022
This way I can easily populate a weekly report.
I hope this makes sense and that someone can help me with this.
Thanks!
Anton
Bookmarks