Macro to copy transposed ranges to master sheet

[lyla22]

Hi

I'm working on a macro to copy specific data from all (identically structured) files in a specified folder into a single master file.

The macro copies a specific selection of ranges in each file and then transposes those into a single row (for each file) in the master file.

It's almost working but when I run the code, it copies the correct selections but won't move to a new row for each file's data.

here is the code I have:

Please Login or Register  to view this content.

I'd really appreciate any help with this.

[AlphaFrog]

Reset the column counter lx to zero for each file

Please Login or Register  to view this content.

[JBeaucaire]

This should do it.

Please Login or Register  to view this content.

[lyla22]

Thank you both!

Alphafrog - works perfectly.

Jerry - only seems to pull data from one file? I can't see where it's going wrong...

[AlphaFrog]

You're welcome.
Jerry's isn't propagating the row counter NR for each file.

[JBeaucaire]

Thanks AlphaFrog, I've updated the code in post #3 to do that correctly. (high-five)

[jolivanes]

Or if your Master Workbook is in the same folder.
With an Array instead of looping for each cell.

Please Login or Register  to view this content.

[lyla22]

Thank you all for your help on this, it's working perfectly.