We help IT Professionals succeed at work.
Get Started
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
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:
and I need to obtain this result
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
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE