Re-sort list when opening spreadsheet

  • Thread starter Thread starter kevlar3d
  • Start date Start date
K

kevlar3d

I have a spreadsheet that pulls information from about 5 othe
spreadsheets, and of course this happens automatically each time th
spreadsheet is opened. My question is, is there a way to re-sort th
list each time that information is pulled?

I am trying to make a top 10 list of my salespeople and I am lookin
for a way to have it re-sort the list automatically after pulling th
updated information from the other spreadsheets.

Suggestions?

Thanks in advanc
 
You could record a macro that sorts the data the way you want it sorted. Then
incorporate that code in your code that updates the values.

Alternatively, you may want to apply data|Filter|autofilter and just let the
users filter to show the info they need.
 
I recorded a macro as you suggested and that worked. I dont reall
understand the autosort suggestion you had, i will have to read th
docs on autosort
 
Autofilter?

Try this on a test worksheet.
Select a range and do Data|Filter|autofilter.

You'll see arrows in the header rows of your selected range. You can use those
arrows to show just the rows you want to see.
 
Back
Top