Forum Discussion
sumrall90
Dec 16, 2020Copper Contributor
Excel Help for fairly new user
I am working on an older worksheet from a excel document some else created that has multiple pages. I have saved this as a new document for me to make changes since this is a new job from the origin...
sumrall90
Dec 16, 2020Copper Contributor
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!!!!
Dec 16, 2020
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.
- sumrall90Dec 16, 2020Copper Contributor
Jihad Al-Jarady Thank you!!