searching a workbook for a number in a range - category based.

[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.

 

[hiker95]

winbawt,

Welcome to the MrExcel forum.

You are posting a picture/graphic. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense.

Can you post screenshots of the raw data worksheets, and, post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker

Even better:

You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.