• 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.

VBA to open excel workbooks from a list and copy it to specific tabs

Rom72

New Member
Hi all,
I am struggling with coding for a requirement that I have.
I have an excel template with the list of report name, cell address where data to be pasted & tabs with name of those specific reports where these reports to be pasted.
My challenge is that I need to open a list of excel workbooks as per the list folder ( all reports & template will be in the same folder), copy the data from those excel books & paste it to these specific tabs to specific range of this excel template.
Can anybody please help. I have uploaded sample files


Thanking you in advance for your help
 

Attachments

  • Recon Sample.xlsm
    11.2 KB · Views: 2
  • Report_1.xlsx
    12.7 KB · Views: 1
  • Report_2.xlsx
    12.7 KB · Views: 0
Back
Top