Wildcard Searches across Worksheets

  • Thread starter Thread starter avilliers
  • Start date Start date
A

avilliers

I need to be able to find the following patterns within my data -
usually within an entire workbook or worksheet:

Annnn (or B3425 as an example)
A = any letter A-Z
n = any number 0-9

This pattern would normally be found repeated in one column of any
worksheet but sometime they get scattered around thus the need to
search the whole workbook/sheet.

Using Excel 2003 here.

Is anyone familiar with using functions to code this or possibly an
add-in? Thanks.

-Alan-
 
I need to be able to find the following patterns within my data -
usually within an entire workbook or worksheet:

Annnn (or B3425 as an example)
A = any letter A-Z
n = any number 0-9

This pattern would normally be found repeated in one column of any
worksheet but sometime they get scattered around thus the need to
search the whole workbook/sheet.

Using Excel 2003 here.

Is anyone familiar with using functions to code this or possibly an
add-in? Thanks.

-Alan-
Click to expand...

Hi.

Can I ask what exactly you want the code to do? Do you want it to
highlight the cells in question, or do you want them copying and
pasting to another sheet?

Regards,
Matt Richardson
http://teachr.blogspot.com
 
Back
Top