Macro to show how many times one number appears with another number

Hello everyone, I would like a macro that asks for a number from 1 to 70 and then searches all the rows in sheet1 and lists on sheet2 column A and B how many times the other numbers appear with it. For example, suppose the number chosen is 1. On sheet2 it would list separately how many times the numbers 2 to 70 appeared with the number 1 in the same row. So in the attached file, after starting the macro and choosing the number 1, excel would look in rows 5, 6, 8, and 10 and list the numbers that appear with 1 in columns A and B as is shown in the example. As stated above, I would like the macro to search all of sheet1 not just the few rows in the attached file. Sheet1 will eventually have many rows of numbers and this will help me greatly. Thanks very much to anyone who can help me.

Omega71,

I'm pretty sure this is what you're looking for:

Please Login or Register  to view this content.

You're very welcome