Formula to Add information on every sheet to match the first sheet in a specific field

I have a user that is looking to add information in the first sheet and then that information would automatically add to each sheet afterwards.

For instance, a workbook has January 2018 as the first sheet, and then each month as another sheet in the workbook. We are looking for a formula we could add in a specific field (In this case, field B2) so that if the user types in something in the first sheet of January 2018, that information will then be added to each subsequent sheet automatically. And, if she changes it, it will change in each sheet.

For example, user types in "Location 1" in field B2 on the January 2018 worksheet. Once she enters this information, we would want February, March, April and so on to also say "Location 1" without her having to type it in to each individual sheet.

I'm pretty sure there is a simple formula to push this, I'm just not sure what it is.

Thanks so much!
TarkisalAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieAnalyst Assistant Commented:
What you could do is select all the sheets apart from the January sheet, and enter this formula in B2.


='January 2018'!B2

That will put the same formula in all the sheets and it will be automatically updated when B2 changes on the January sheet.
0
Rob HensonFinance AnalystCommented:
Might be worth giving the cell on January sheet a range name eg "Location"; ensure the range name has Workbook scope rather than Worksheet.

On the other sheets, as suggested by Norie, it is then a simple formula:  =Location
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob HensonFinance AnalystCommented:
Both answers give basically the same info
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.