Copying AND pasting (transpose) from multiple workbooks to one master workbook

hjackson

New Member
Joined
Oct 7, 2019
Messages
2
Hi there

I have several workbooks in one folder that I need to open and copy a number of cells (G2:O2) from the same sheet name ('Output Create') for all of the workbooks into a 'Master' spreadsheet. Within this Master spreadsheet Column A contains a name of a place, which partially matches the filename of the several workbooks I have in that one folder. I would like to be able to paste (transpose) the values in the right cells by matching the filename to the names in Column A.

Could someone advise me on a template of what the VBA would look like for this?
Happy to expand on this if detail is needed

Thanks in advance
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

hjackson

New Member
Joined
Oct 7, 2019
Messages
2
Thanks for the link.

I'm unsure whether this is directly related to my query.

My Master sheet is like this:

Column A Column B Column C
Name1 Paste value from G2
Name1 Paste value from H2
Name1 Paste value from I2
Name1 Paste value from J2
Name1 Paste value from K2
Name2 Paste value from G2
Name2 Paste value from H2
Name2
Name2
Name2

My file names contain part of the name in column A so I want the corresponding value pasted in Column C.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,246
Messages
5,449,232
Members
405,559
Latest member
Chelseytx

This Week's Hot Topics

Top