Copy data from one workbook to another based on the sheet name and column name

lewismortonwood

New Member
Joined
Jan 11, 2018
Messages
6
Hi,

Column A of Sheet 1 in the first workbook(1) contains the worksheet names that correspond to a second workbook(2)'s worksheet names.

Row 1 of Sheet 1 in workbook(1) contains the names of each column. Row 1 of each worksheet in workbook(2) also contain the names of the columns but they are in a different order than in workbook(1).

I need a code that will match the values in column A, of Sheet 1, in workbook(1), to the corresponding worksheet in workbook(2)
Once matched, I then need to cycle through the columns in Sheet 1, workbook(1), match the column name in Row 1 to the column name in Row 1 of workbook(2) for the matched worksheet
The data from each column in Sheet 1, workbook(1), from Row 2 downwards, then needs to be copied and pasted into Row 2 of the corresponding matched column in the matched worksheet of workbook(2)

This is something that I have no idea how to attempt and no time in which to attempt it!

I would appreciate some expert help. Thank you
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Forum statistics

Threads
1,089,228
Messages
5,406,998
Members
403,117
Latest member
redblasko

This Week's Hot Topics

Top