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?
 
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
 
NorieVBA ExpertCommented:
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:
Both answers give basically the same info
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.