imapoboy2
New member
- Joined
- Jul 2, 2013
- Messages
- 12
- Reaction score
- 0
- Points
- 1
- Age
- 56
- Location
- Wisconsin
- Excel Version(s)
- 2013
I have a workbook that includes a master sheet, along with regional sheets. (e.g. Master, NW Region, SW Region, SE Region, etc.) The Master sheet includes a column that identifies the appropriate region.
I would like to be able to enter the required information on the Master worksheet, and have that information auto-populate or auto-update onto the corresponding regional worksheet, which has an identical layout.
I am only a novice at formulas, so any help from the forum would be greatly appreciated.
A | B | C | D | E |
| Contract# | Region | Data 1 | Data 2 |
1 | 2024-011 | NW Region | 123 | 456 |
2 | 2024-012 | SW Region | 789 | 101 |
3 | 2024-013 | NE Region | 858 | 665 |
I would like to be able to enter the required information on the Master worksheet, and have that information auto-populate or auto-update onto the corresponding regional worksheet, which has an identical layout.
I am only a novice at formulas, so any help from the forum would be greatly appreciated.