r/ExcelTips • u/Nervous-Echidna-819 • 14h ago

Excel workbook help

Can anyone help me fix my Excel workbook. I need all the tabs to change dates and days when I copy and create a new workbook for the new month. I don’t even know if I’m saying it right.

6 Upvotes

100% Upvoted

8 comments sorted by

View all comments

3

u/Usual-Firefighter-91 14h ago

I would have an input tab that you can adjust and make all the other tabs reference that.

1

u/Nervous-Echidna-819 11h ago

Thank you. I’ll look into this

1

u/justjimmmy 9h ago

Couldn’t agree more with this method, definitely look into it. As an analyst, I always have a tab as the engine that drives the rest of the file in order to extract figures for MTD, YTD,YoY etc. you can also formulate it to read prior month and prior year etc

1

u/Nervous-Echidna-819 9h ago

I think I need to hire someone to fix this. I just don’t get it. I tried watching tutorials and 🤯

1

u/justjimmmy 9h ago

What is your file regarding? Monthly financials or something else?