Filtering

  • Thread starter Thread starter Yvette
  • Start date Start date
Y

Yvette

Can anyone please help me? i have an existing excel
worksheet and whenever i add new data to it, it doesn't
get included in my filtering. Instead all new data is
tacked on the end of what ever i have filtered. If I
save the data to a new worksheet, it filters ok, but
again if i add any new data, it doesn't get included in
the filtering. This is extremely frustrating and a
complete enigma to me. Any advice would be greatly
accepted.
 
You have to remove the filter and reapply it.

You might create a dynamic named range named Database that expands as you
add data, but even then I believe you would need to remove and reapply the
filter.
 
Tom,
You are a genius, THANK YOU!!!!
You have saved me from going bald, much appreciated,
Yvette.
 
Back
Top