I am doing a daily report and I am inputting all the formulas in but is there an easier way to have it automatically add the previous day without having to type in the previos sheet number each and every time...
=(Sheet185!$F$5)+B5 then the next day =(Sheet186!$F$5)+B5...then next day =(Sheet187!$F$5)+B5...i have so many formulas that it takes forever to just go back through and change one number each day..I have already copied all the formulas over up until the end of this year but now I have to go back and change each sheet number on each formula..ugh..i just want a way for it automatically puts the previous sheet number in..
I'm sorry if this is a stupid question as I am pretty new to this..help please
Thanks in advance!
[SOLVED]
Bookmarks