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

[hjackson]

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

 

[dmt32]

Hi,
welcome to forum

Have a look at Ron de Bruin site here:https://docs.microsoft.com/en-us/pr...007/cc837974(v=office.12)?redirectedfrom=MSDN

and see if solution he offers here will help you.

Dave

 

[hjackson]

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.