View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
johnski13 johnski13 is offline
external usenet poster
 
Posts: 2
Default can a linked spreadsheets sort automatically when data is added

I have a linked spreadsheet that I would like to sort automatically. It is
linked to main a spreadsheet that contains the data. Basically, I want the
spreadsheet to have the rows sorted after data has been entered into the main
spreadsheet. The spreadsheet is linked using vlookup.

The linked spreadsheet is a snapshot of the main one and I currently
manually sort it after data is entered in the main. Basically, the linked
spreadsheet shows a ranking (highest to lowest) of total equalizations hours.
Since I update the main spreadsheet throughout the day, I would like the
linked spreadsheet to sort automatically.

Any help on this would be greatly appreciated.