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
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...
