Hi
I would be grateful for some help writing a looping code/paste range code.
I would like to populate the Results table by looking up the Year column and paste values of column A B & C. I can do this as a normal vlookup formula but I have a large number of columns and manually editing which column to return is taking forever. I figured there must be a clever VBA way.
Any help/advice would be great. Thanks
RESULTS TABLE
Year A B C
1
2
DATA TABLE
Year A B C
30Jan 5 7 3
30Sep 5 7 4
1 10 14 7
30Jan 3 5 1
30Sep 12 2 5
2 15 7 6
I would be grateful for some help writing a looping code/paste range code.
I would like to populate the Results table by looking up the Year column and paste values of column A B & C. I can do this as a normal vlookup formula but I have a large number of columns and manually editing which column to return is taking forever. I figured there must be a clever VBA way.
Any help/advice would be great. Thanks
RESULTS TABLE
Year A B C
1
2
DATA TABLE
Year A B C
30Jan 5 7 3
30Sep 5 7 4
1 10 14 7
30Jan 3 5 1
30Sep 12 2 5
2 15 7 6
