Loop through each sheets in the workbook to find specific cell on my table

Hi Guys,

Hope someone could help me with looping regarding (for each cell in the column A (sheet 16), loop in all sheet to find it and the value should be column B)

My problem is somehow similar to VLOOKUP in the sense that I have a workbook with 15 sheets (each sheets contains 1 Million rows) and 1 Sheet for my summary.

On my summary, I have Column A (with 100 lines). What I would like to do is to search each item on this column in all 15 sheets of the workbook and once identified, the cell value will be the cell value beside it (column b).

Thank you in advance,

Regards

Air code - untested as no workbook provided by OP to test.

Please Login or Register  to view this content.

Thanks for posting a sample worksheet. I have modified the code slightly and tested. This new code works on the example as required.

Please Login or Register  to view this content.