identical sheets where copies update

[michaelpaul]

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

 

[johnwm]

You can reference a cell value from one workbook to another directly:

=[myfile.xls]Sheet3!$J$3

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

UK steam enthusiasts:

http://www.essexsteam.co.uk

 

[electricpete]

Yes, I agree with johnwm, the easy part is getting data linked from one spreadsheet to another spreadsheet.

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.

 

[IFRs]

You might be able to use Custom Views and assign macro keys to switch between them, showing different sorts and filters.

 

[michaelpaul]

thanks for the suggestions.

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