View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RussG RussG is offline
external usenet poster
 
Posts: 9
Default "Live" Advanced Filter (for unique records)

Is there a function, or other method, to maintain a real-time list of unique
records. In other words, I'd like to NOT have to manually run Advanced
Filter/Paste every time a new unique record is added. I assume I could do
this with a macro, but am trying to keep the file macro-free. Any
suggestions?
Thanks as always!