How do I update filters when using Autofilter?

S

SunGod_69

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?
 
M

Max

SunGod_69 said:
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
Click to expand...

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.
 
S

SunGod_69

Thanks Max - Brilliant! Fixed the problem.

Max said:
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.
Click to expand...
 
Top