Avatar of Leonel Garcia
Leonel Garcia

asked on 

Order table with macro

Greetings to all;

First of all many thanks for the time to read my question, I've been reviewed in the forum but I have not had capable to find something similar, I have the following table:
Initial table
and I need to obtain this result

Final table
I've used Vlookup in VBA but this function only gives me the 1st result founded.

The reason I need to do this with macros is because this re-arrangement will be part of a loop process with information from different sources, but requiring the same treatment.

I'll be very grateful for any idea / comment or suggestion.

Best regards
Table.xlsx
VBAMicrosoft ExcelSpreadsheetsMicrosoft OfficeProgramming

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon