michaelpaul
Mechanical
- Apr 7, 2005
- 2
I'm just curious if there's a way to set up a set of sheets to mirror a "master" and always update their data if data in the "master" has been changed.
going one step further, I have sevral sheets that all represent the same data but they present the data with different sort variables so i can just go from one sheet to another instead of sorting the same sheet different times.
ideally, I would like to enter data into one master list and have the other sheets reference this master but still be sorted on the appropriate variable.
I've got a work around right now where I use some macros to basically automate a cut and paste of the master data into each sheet and then sort on the variable. while it's automated, it was kind of tedious to set up and I'd rather not reproduce that effort on other spreadsheets that require similiar data input and manipulation.
thanks
going one step further, I have sevral sheets that all represent the same data but they present the data with different sort variables so i can just go from one sheet to another instead of sorting the same sheet different times.
ideally, I would like to enter data into one master list and have the other sheets reference this master but still be sorted on the appropriate variable.
I've got a work around right now where I use some macros to basically automate a cut and paste of the master data into each sheet and then sort on the variable. while it's automated, it was kind of tedious to set up and I'd rather not reproduce that effort on other spreadsheets that require similiar data input and manipulation.
thanks
