LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
seeking help on how to automatically shift an average range as new data is added [email protected] Excel Discussion (Misc queries) 2 August 30th 07 05:59 PM
repost: seeking help on how to automatically shift an average range as new data is added [email protected] Excel Discussion (Misc queries) 0 August 30th 07 02:36 PM
automatically expand chart data series as data is added jlarson Charts and Charting in Excel 1 March 9th 06 10:31 AM
Data added to a spreadsheet will not automatically add, help! CBP Excel Discussion (Misc queries) 1 February 21st 06 06:47 PM
Automatically insert fill colour when data is added? suzi Excel Worksheet Functions 2 November 17th 04 02:55 PM


All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"