Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I update filters when using Autofilter?
I have copied a worksheet with Autofilters but find a number of missing
entries in the new worksheet. It does not seem to be updating itself with either existing entries in the column or new ones being added to that column. How do I fix this problem? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I update filters when using Autofilter?
"SunGod_69" wrote:
I have copied a worksheet with Autofilters but find a number of missing entries in the new worksheet. It does not seem to be updating itself with either existing entries in the column or new ones being added to that column. How do I fix this problem One possibility is that there could be "breaks" (empty rows) within the table of data. Try this: Remove the autofilter, press CTRL+END to go to the last used cell (bottomest right cell), then re-select the entire table from that last used cell/last row up, then re-apply the autofilter. The autofilter should work ok now. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I update filters when using Autofilter?
Thanks Max - Brilliant! Fixed the problem.
"Max" wrote: "SunGod_69" wrote: I have copied a worksheet with Autofilters but find a number of missing entries in the new worksheet. It does not seem to be updating itself with either existing entries in the column or new ones being added to that column. How do I fix this problem One possibility is that there could be "breaks" (empty rows) within the table of data. Try this: Remove the autofilter, press CTRL+END to go to the last used cell (bottomest right cell), then re-select the entire table from that last used cell/last row up, then re-apply the autofilter. The autofilter should work ok now. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I update filters when using Autofilter?
"SunGod_69" wrote:
Thanks Max - Brilliant! Fixed the problem. Glad to know it helped ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
Auto update of filters | Excel Discussion (Misc queries) | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel |