Will Advanced Autofilter updates the cell values ?

[kaffal]

I used the Data -> Filter -> Advanced Autofilter in one of my worksheet from a pool of data, to sort out unique customer ID, to remove those duplicates.
But I found out that when I make changes to the pool of data. Those filtered out data I sort out previously does not update accordingly to the new pool of data. Is there any option to to use in excel, to refresh the autofiltered data?

[Big Chris]

Kaffal,

Maybe a small macro to under the filters and put them back on again?

Something like:

(firstly to undo)
Selection.AutoFilter Field:=1
Selection.AutoFilter Field:=2
Selection.AutoFilter Field:=3

(then to rest to your chosen criteria)
Selection.AutoFilter Field:=1, Criteria1:="yellow"
Selection.AutoFilter Field:=2, Criteria1:="7"
Selection.AutoFilter Field:=3, Criteria1:="yes"

...and just place a small button on the worksheet that will run the macro and give you what you need.

HTH,

Chris.