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
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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.
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,938
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top