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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,089,840
Messages
5,410,701
Members
403,325
Latest member
sherrir

This Week's Hot Topics

Top