View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
golddave via OfficeKB.com golddave via OfficeKB.com is offline
external usenet poster
 
Posts: 11
Default List Disctinct Strings from Range of Cells

I cannot use a macro. Client does not allow macros as it is a vector for
viruses.

Pete_UK wrote:
Yes, but Luke advised you earlier that you can record a macro while
you do it once, assign a button (or hot-key) to that macro, and then
just re-run the macro when you need to.

Hope this helps.

Pete

I also need it to dynamically update since it's going to be used by non-
technical people who can't be expected to run the filter mechanism.

[quoted text clipped - 17 lines]

- Show quoted text -


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1