Good afternoon. first post.
I am by no means an expert but i can do the basics in Excel (2016). i have created a simple data capture sheet that is used weekly in a briefing (copied and pasted to PowerPoint). On the left i have a list of activities (A5-A11). Columns B5-11 and C5-11 represent the previous month (i input numbers for two separate activities) Columns D,E, represent the current with F,G representing the future.B-G 12 represent a total of each of the above while B13 and 14 would be a 'rolling' total of D,E 13 respectively (with the raw data being taken from D,E as my current month).
I hope that kind of makes sense? what i am trying to achieve is that B13 and 14 remain the accumulative (rolling) totals so when i remove the numbers from D&E 5-11, it doesn't affect the total (but only if i have to adjust a number say from 5 to 4)
ill see if i can upload an image.
I am by no means an expert but i can do the basics in Excel (2016). i have created a simple data capture sheet that is used weekly in a briefing (copied and pasted to PowerPoint). On the left i have a list of activities (A5-A11). Columns B5-11 and C5-11 represent the previous month (i input numbers for two separate activities) Columns D,E, represent the current with F,G representing the future.B-G 12 represent a total of each of the above while B13 and 14 would be a 'rolling' total of D,E 13 respectively (with the raw data being taken from D,E as my current month).
I hope that kind of makes sense? what i am trying to achieve is that B13 and 14 remain the accumulative (rolling) totals so when i remove the numbers from D&E 5-11, it doesn't affect the total (but only if i have to adjust a number say from 5 to 4)
ill see if i can upload an image.