Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a filtered list (VisibleCellsOnly) be sorted?
2003
Would like to sort visible cells only in a filtered w/s. Common sense tells me no. I realize that I could copy the filtered data to a separate sheet and then sort. That said, I would the information on NewSheet to replace the respective information from the original filtered sheet. What logic/knowledge am I missing? Any help appreciated! EagleOne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a filtered list (VisibleCellsOnly) be sorted?
Heve you tried it? It works for me in XL97 on a simple test.
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk wrote in message ... 2003 Would like to sort visible cells only in a filtered w/s. Common sense tells me no. I realize that I could copy the filtered data to a separate sheet and then sort. That said, I would the information on NewSheet to replace the respective information from the original filtered sheet. What logic/knowledge am I missing? Any help appreciated! EagleOne |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a filtered list (VisibleCellsOnly) be sorted?
Sandy,
I did try, and got a "multiple segment (or selection)" error. I'll make a few more attempts. Thanks EagleOne "Sandy Mann" wrote: Heve you tried it? It works for me in XL97 on a simple test. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation (list) that can be sorted | Excel Discussion (Misc queries) | |||
Excel data filtered and sorted --- how can i get the workbook to D | Excel Discussion (Misc queries) | |||
Sorted list | Excel Discussion (Misc queries) | |||
Need sorted validation list | Excel Worksheet Functions | |||
filtered sorted packing list report from data table | Excel Discussion (Misc queries) |