Wildcard Searches across Worksheets

[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-

 

[Matt Richardson]

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-

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