Find, Match, copy and format

[anep67]

Hello to all gurus here..

I am quite new to macros and vba and cracking my head to solve this problem but I don't know whether it is possible.

I have just say about 100 four digits numbers in column A and the code should take the first number find the identical number then copy both the first number and the matching in column B and loop through the rest of the list. That sounds pretty easy right but here's the problem:

The matching pattern is like this -

Just say the number is 1234 then it should look for

a) the exact number
b) all the permutation ie 1432, 1324, 2314 etc..
c) 123?, 12?4, 1?34, 1?234 (ie 1254, 9234, 1238 etc)
d) backward - 432?, 43?1, 4?21, ?321 (ie 4329, 8321, 4921 etc)

Any advise are much appreciated.

Thank you in advance

[wayusei]

I don't understand what's the code supposed to do. Could you rephrase in a step by step manner, please?

[anep67]

Hi wayusei,

Thanks for the reply.

The code suppose to get the first number and match to the rest of the numbers according to the conditions stated above and copy the matching numbers in column B.

Example:

Column A Column B
1234 1234
2456 4312
4312 1234
5826 1294
1294 1234
4326 4326

The above is exactly what I wanted. It means the code get the first number from Column A and find matching numbers in column A and then copy both in Column B. Then it goes to second number in Column A and do the same again until the end. However the matching condition is as follows:

a) the exact number ie 1234
b) all the permutation ie 1432, 1324, 2314 etc..
c) 123?, 12?4, 1?34, ?234 (ie 1254, 9234, 1238 etc)
d) backward - 432?, 43?1, 4?21, ?321 (ie 4329, 8321, 4921 etc)

Please let me know if you have any questions.

Thanks

[anep67]

Anyone can help me out here? I guess this is not possible in vba. Anyway thanks... back to manual...