VBA - VLOOKUP Multi criteria

Hello everybody,

I have a problem, I can't find the right method to consolidate my table. I need to search instance with 3 criteria.
I join this one to simplify the explication.

Thanks you in advance for your support

I found how to consolidate first row, but now I have just a new problem to loop this script...

So in sheet "PROD" each 11 rows, we have a new table with another item. I would like to loop this script each 11 rows

I have got a idea ?

Please Login or Register  to view this content.