N
nikmasteed
I have a range of data that I would like to sort with different criteria
on different sheets: in other words I want sheet 2 to be sorted by disc
number, sheet 3 to be sorted by job number, and sheet 1 to be a kind of
master list sorted alphabetically. Is there a way I can link these
sheets so that any updates I make on Sheet 1 will automatically be
reflected on the other sheets and sorted correctly? I'd like to make
it easy to make changes to these lists without having to update each
one. Any help is appreciated.
on different sheets: in other words I want sheet 2 to be sorted by disc
number, sheet 3 to be sorted by job number, and sheet 1 to be a kind of
master list sorted alphabetically. Is there a way I can link these
sheets so that any updates I make on Sheet 1 will automatically be
reflected on the other sheets and sorted correctly? I'd like to make
it easy to make changes to these lists without having to update each
one. Any help is appreciated.