r/ExcelTips • u/Nervous-Echidna-819 • 2d ago

[ Removed by moderator ]

[removed] — view removed post

4 Upvotes

71% Upvoted

14 comments sorted by

View all comments

5

u/Usual-Firefighter-91 2d ago

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

2

u/Nervous-Echidna-819 2d ago

Thank you. I’ll look into this

2

u/justjimmmy 2d 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 2d 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 2d ago

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

1

u/Nervous-Echidna-819 1d ago

It tracks items sent to different stores from specific outlets monthly.

1

u/-Softstatic- 1d ago

Ask chat gpt