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!