same range, multiple sheets, different sorts, help please!

  • Thread starter Thread starter nikmasteed
  • Start date Start date
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
Tricky problem - auto-sorting without VBA 7
Sort sheet based on particuilar sort order 4
How do I link each cell to each worksheet to change as I enter dat 6
Auto sort help. 2
Match and delete rows on two different sheets from reference numbers 4
For Each Sheet in Range - Sort Descending 7
What type of "lookup" 3

Back
Top