code help - consolidating multiple workbooks into one worksheet

Hi,

I'm quite new to VBScript but for the past day I've been trying to consolidate certain data onto one sheet. I got it to work in when it is all from one workbook, but now I'm trying to go by folder. What I have below is not working, and it seems to just be around where I'm trying to copy and paste the data.

Basically in any given workbook I only have one tab and all I need from each one is the information from D2:D61 pasted as transposed into a new masterworkbook (or just a new sheet in the workbook I have open, anything works)

Please Login or Register  to view this content.

Any help is greatly appreciated!

Your code is pasting to the activesheet, which will be the one with the data in - the workbook that has been opened.

See if this works

Please Login or Register  to view this content.