I'm wondering if someone may be able to help me with this...
I have made a sheet that will give me a daily capacity roll over flow and it works really well.
I originally made it for just six weeks but found It difficult to come up with a way to copy the formulas across due to the cell references so i had to do a lot of the work manually.
this obviously took a while with 46 columns x 46 rows.
i would somehow now like to extend this sheet to do a whole year but with 365 columns x 365 rows I would really like to know if anyone has any ideas on how to make this task easier than before.
i have attached an example of 2 weeks with data inputted for 1 week, thanks in advance for your help.
here is an example sheet
Bookmarks