identical sheets where copies update
identical sheets where copies update
(OP)
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





RE: identical sheets where copies update
=[myfile.xls]Sheet3!$J$3
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: identical sheets where copies update
The tough part is the sorting part. If there were a function like sort(block1,column2) which returned a sorted block you would be in business. I don't remember any such function although I'm sure the vba wizards have built on in some of the available excel add-ons.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: identical sheets where copies update
RE: identical sheets where copies update
I think I can simplify my workaround so that it is adaptable to a more general case based on your suggestions. It will still require a macro to perform the sort but it should be a simpler implementation than what I have now.
Michael