Button-macro to read ranges of cells and return values of other cells based on results

Hey Excel-lent people!

I've attached a sample spreadsheet. Here's what I'm trying to do.

Let's say that I click the button labeled "40k thru 50k". Well, I'd like it to return a list of all the cells within ranges D5:D16, F5:F16, H5:H16, K5:K16, M5:M16 and O5:O16 whose values are greater than 40000 and less than 50000, and for each one, I'd like the corresponding index data. So if you click the 40k thru 50k button, you'd get a list like this:

GE-12-Step 3
RT-11-Step 2
RT-12-Step 2
RT-08-Step 3
RT-09- Step 3

I'd like the list to be populated in the sheet, if possible because that will be easier to print each time you run the macro, but a pop-up would also serve this purpose well.

Thank you guys! This forum is really super mega cool and I like you guys and think most of you are very attractive.

Originally Posted by sintek

Cells(2, 17) refers Q2
change it to cells(22,3) refers C22

You are a wizard. I'm terrified of your power!!!

Thank you so much!

Hey there! I'm trying to PM you but I'm having trouble for some reason.

Anyway, the code is working well, but in my finished product, I'm running into some weird snags. I'm getting an "application-defined or object-defined error" on one line, but only when I run the macro with the range set to certain numbers.

Can I send you the book?