Lookup Number on "Summary" Sheet and Loop Through All Worksheets

Hi I need to lookup a number on the "Summary" Sheet in Cell G2 and want it to loop through all worksheets until it finds the number, when it finds the number, I want it to return the worksheet name in cell B2 on the "Summary" Sheet. Have to do it for about 1000 unique numbers.

Can anyone help??

Please Login or Register  to view this content.

This didn't work, it needs to return the worksheet name, instead its returning something completely different.

What is it returning? Can you post an example workbook that replicates the problem, along with what you are expecting it to return?

For example, it finds looks up number 103050 in G2 on the Summary tab, finds it on the 5th worksheet in Column G, then I want it to go back to Summary tab and put the 5th worksheet name as the value into cell B2.

That's what the code should be doing, and that's how it works for me when i test it. Again, please post example workbook that replicates the error, along with expected results.

I'm sorry it works, I adjusted, but you're awesome. Thanks!

Sorry, how can I get it to search the loan, not on the entire worksheet, but only in column F (currently the code searches through the entire sheet).

Switch out the Set c line with this

Please Login or Register  to view this content.

Again you're awesome. Thanks

Doesn't work!!! It doesn't return anything!!

Again, would be really helpful if I could see an example workbook of yours that returns the error. The syntax is correct, so it could be anything from formatting to range discrepancies to variable types. Hard to diagnose blind.

See attached!

Any luck??

Yes. I changed nothing, i just ran the code you have in the attached, and I got the results I would expect. See screenshot. Not sure what to tell you at this point.... Try running it again?

vbkt.png