Search, find, cut and paste macro

[Omega71]

Hello, I would appreciate it very much if anyone could help me with this problem. My problem is this: In column A I have a list of numbers ranging from 0000 to 9999, and in column B I have their corresponding frequencies. What I need is a macro that will ask the user for four numbers and then to search column A and then to extract those four numbers and any combination of those numbers plus their frequencies and to place them in Columns D and E. For example, the user inputs 1234, 1234 and all combinations such as 2134 , 4312 , 3214 etc and their frequencies are extracted from Columns A and B placed in Column D and E. I hope I have explained the problem clearly. Thank you to anyone who can help me with this.

[arlu1201]

Please attach a sample file, it will surely be helpful.

[Omega71]

Hello arlu1201, I have attached the file and it shows Columns A and B with the data. In Columns D and E I have placed the results that I would like the macro to display. If I can get the macro to just show me the results without cutting and pasting them, that would be okay too. I tried using the FIND function but not sure how to get it to find any combination of the four digits. I can only find the exact match but I need all possible combinations. Any help would be great. Thanks.

[nilem]

Try this. Author of the code - YOSHIDA Hajime (Aug. 23, 2001).

[Omega71]

Hey nilem, That is exactly what I was looking for. Thanks very much for your help. Take care.