Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default why sort decending doesn't refresh when data changes?

why sort decending doesn't refresh when data changes?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default why sort decending doesn't refresh when data changes?

It's a one-off command that sorts when you do it (rather like autofilter).
If you wanted to update the sort order continuously, you could do it by
formula or have an event macro running in the background.

Hope this helps.

Pete

"Abdul" wrote in message
...
why sort decending doesn't refresh when data changes?



Reply
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
Create refresh button in worksheet to refresh Pivot Table Data Ron Excel Worksheet Functions 1 October 13th 07 01:20 AM
Data ascending and decending Linda Excel Discussion (Misc queries) 3 March 16th 07 12:14 AM
Lookup function experts.. I need ascending and decending lookups of a series of data.. can you help me sort this out BillReese Excel Worksheet Functions 6 May 3rd 06 04:15 AM
sort data by criteria other than ascending or decending HV man Excel Worksheet Functions 1 March 29th 06 05:24 AM
Order Data in Pivot Table Non ascending or Decending [email protected] Excel Discussion (Misc queries) 1 June 3rd 05 01:00 PM


All times are GMT +1. The time now is 04:40 AM.

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

About Us

"It's about Microsoft Excel"