Thread: Find Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jerry[_22_] Jerry[_22_] is offline
external usenet poster
 
Posts: 3
Default Find Macro

I have a workbook with multiple sheets and thousands of entries. I would
like to search the workbook for entries that would be similar to this:

abcde-s-1234 or efghij-s-56789

The only common this is the -s- in the cells that would be 5 or 6 places
over from the left. I would like to locate all the -s entries and write them
to another sheet or workbook.

Thanks,
Jerry