Hi There,

I am trying to copy and paste ranges from many workbooks into a seperate worksheet

The workbooks are in a forlder called C:\Invoices

The ranges I would like to copy and paste to the seperate worksheet is

Sheets("Invoice").Range ("M3,D13:H13,E17,M13")

I would like to be able to loop through all the workbooks in the folder, and have the ranges pasted one row then the next row ect.


Is there a way this can be performed?