Macro to find variations on a search value

[edbyford]

Hello all,

I have a list of numbers; some are 12345, some are 000012345, some are ABC00012345, some are .12345, some are 000-0012345-000. There is no standard format, they might be a combination of these.

I need a macro to ask the user for a value to search, then search for variations of this number, and return likely matches, preferably by copying the whole row of data to a new sheet.

This is a challenge, any help greatly appreciated!

[patel45]

attach please a sample