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


New Member
Oct 7, 2019
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


New Member
Oct 7, 2019
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

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

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...