Greetings All,
I have a problem with the total sum on weekly update as I need to change the date update in the weekly update sheet.
1. =SUM('1.1.19:6.1.19'!B11) is first week then manually need to change to =(SUM7.1.19:12.1.19'B11) for the second week.
2. In date RP movement sheet also need to change manually the date and cell to update the totals.
Thank you
This may be of some help.
On the RP movement sheet a helper column, which may be moved and/or hidden for aesthetic purposes, is populated using: =TEXT(B5,"d.m.yy")
Also cells H1:I1 are populated with the cell that needs to be referenced on each sheet.
The values in the C12 and C14 columns may then be populated using: =INDIRECT("'"&$G5&"'!"&H$1)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks