The fastest way to loop in 2 tables

[jaryszek]

Hi,

i have source table like here:

Screenshot_6.png

The goal is to loop through all rows and for specific column names provided in column B populate values in tables in specific sheets.
So for Tab1 Scenario we will get the result like here:

Screenshot_7.png

How to do this in the best possible way ?

Best wishes,
Jacek

[Mumps1]

Try:

Please Login or Register  to view this content.

[jaryszek]

thank you Mumps.

Hmm interesting approach.
Copying and paste would be good if we will have column names in order. But i can have situation where i have only column3 in Tab2 Scenario to fullfill.

Screenshot_11.png

So copying will be not good.

Best,
Jacek

[Marc L]

Hi !

In this case you may use an advanced filter - Excel basics ! - which can copy only by headers whatever their destination order
and that needs a single codeline …

[jaryszek]

hi,

thank you Marc L.

Best,
Jacek

[Mumps1]

Has your problem been solved? If not, you can simply insert some code at the beginning of the macro to sort the "Source" sheet by column B in ascending order.