If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Copy column values if data on row 1 has a certain text that is the same in another sheet, then loop through for the rest of the columns

Thread starter Hestia
Start date Nov 8, 2018
Tags

column copy copy and paste macro row workbook

Hestia

New Member

Nov 8, 2018

Hi all

I am still new to Excel VBA as a whole, and would like to seek help from experts regarding a new issue I have.

I would like to copy a column of data from workbook 1 into workbook 2, based on the data it has on row 1.

For example, row 1 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 excluding row 1, and paste it in a column of workbook 2 whose first row has "Argentina" only.

Is it alright if anyone could help me with this? I am not sure of how to program this in excel vba.

Thank you for your help!