How do I update filters when using Autofilter?

[Guest]

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?

 

[Guest]

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.

---

 

[Guest]

Thanks Max - Brilliant! Fixed the 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.

---

 

[Guest]

Thanks Max - Brilliant! Fixed the problem.

Glad to know it helped !

---