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

Copy Named Range "Incidents" from multiple workbooks into a new sheet

V

Vinod Menon

New Member
Dear All,

I have a folder C:\Work\AllBranches\ which contains multiple workbooks like Mumbai.xlsx, Chennai.xlsx, Delhi.xlsx etc.
Each Workbook has a "Named Range" defined as INCIDENTS which contain the data.

I would like a macro which can open all the workbooks, search for the range "INCIDENTS" and copy the data into a new sheet of a master workbook in a stacked order (one below the other). Also would like the first column of the master workbook to capture the filename.

Please help.

Regards,
Vinod
 
You must log in or register to reply here.
Back
Top