• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copying from Mutiple files

V

Veeru106

Member
Hi,

I looking for a solution ,where by running a code we can copy data from 7 different files and paste in master file in their respective 7 tabs.

we can store all these 8 files in one folder and code can identify files from this folder and paste in master file in that particular tab.

Any help will be appreciated .

Please note we don't want to just combine these 7 sheets into one workbook. we want to copy and paste only.

Thank you very much
 
Which sheet(s) will you copy, a named sheet or the first one or? Are the slave files of one type like XLS, XLSX, XLSM, etc.?

Is this a one time thing or will multiple runs need to check if the sheet(s) exists in the master file? It sheet exists in master file, it would paste all data to the first row in a sheet's column A's first blank cell?
 
You must log in or register to reply here.
Back
Top