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?

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

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

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