Thread: Find and report
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fgwiii[_2_] fgwiii[_2_] is offline
external usenet poster
 
Posts: 36
Default Find and report

Good morning,

I am trying to find a way to search a spreadsheet that contains several
hundreds of thousands of dates. Searching isn't really the problem, reporting
however is the issue.

What I would like is, to be able to search all of the cells in a worksheet
for a letter such as €śm€ť and then automatically produce a report (worksheet)
that contains all of the values that match that criteria as well as
referencing the header/column letter where the cell was found.

Thank you for your help,

Fred