I am still new to Excel VBA as a whole, and would like to seek help from experts regarding a new issue I have. Using vba macros, I would like to copy a column of data from workbook 1 into workbook 2, based on the data it has on row 3, then loop through for the rest of the columns.
For example, the cell on row 3 of column C in 'workbook 1' has text called "U.S. Exports to Argentina of Crude Oil (Thousand Barrels)". I would like to copy the whole column and paste it in a column of 'workbook 2' whose first row has "Argentina", since both cells have "Argentina".
Is it alright if anyone could help me with this?
Thank you for your help!