Forum Discussion
Excel Help for fairly new user
It seems that you added a number to the formula in sheet (Jan 18-24), see the attached photo.
I fixed the formula to be like the one on the first sheets.es
Jihad Al-Jarady Also, can you tell me what I am doing wrong when I am trying to manually type in the formula? I have tried to copy and paste the formula and then manually type it in and it will not let me, brings up the save to a folder screen or gives me an error message?
Thank you!!!!
Jihad Al-Jarady Thank you so much for your help!!! May I ask you another question please. If and when I need to add more pages to the document (to add more weeks) and I need the information to continue as is, how do I get the numbers to continue to add to the totals in the new page that I need to add? Again, thank you so much for your help!!!!
I am glad that worked for you.
Regarding your how to do it with the new sheets, you can use just copy the one of the ready sheets and change the sheet name in the formula,
or if you have a lot of sheets you will need VBA code (not sure if there is simpler way) so it is better you write this question as a new post.
Jihad Al-Jarady Thank you!!
