search through the whole workbook for a value that falls in a range, with category

[winbawt]

Hey guys:

So I'm going to have a workbook where each person has their own sheet. Each sheet will be the same, just the data will differ.

I need to be able to search the workbook for a number that will fall in the range of a specific category.

The categories are 1, 2 and 3. Each person has a first and last number, with a scope. Let's say the number I want to find in the workbook is: 54567 under category 2. Since the sample workbook is very small, it's easy to identify that it is on sheet "person3" and would fall in the bottom portion. If this workbook had thousands of entries like this, it would be very difficult to find.

Can someone help me write a function/macro/script (whatever it would be) to search for a number in a specific category?

To clarify: I want to be able to specify a category (for example, category 2), and then specific a number I'm looking for (who would be responsible for that number, for example, # 54567) and have the macro/function/script search through all the sheets of the workbook for that number and tell me who's responsible for it, and if possible, pinpoint that cell.

Thanks in advance.

example.xlsx

[JBeaucaire]

This should do it:

Please Login or Register  to view this content.

[winbawt]

This solved my issue, much appreciated!

[JBeaucaire]

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above and mark this thread as SOLVED. Thanks.

[winbawt]

I had already marked it solved before I replied. Just wanted to show some gratitude.