Link to home
Start Free TrialLog in
Avatar of Tarkisal
Tarkisal

asked on

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!
SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Both answers give basically the same info