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

Extract data from merged multiple excel file to single excel file

P

Purushottam

New Member
I have more than 150 merged cells excel files naming Report, Report(1),Report(2)..etc. i want to extract data from these excel files to single excel file Both Report file and Sample file attached herewith.
 

Attachments

  • Report.xls
    904.5 KB · Views: 4
  • Sample File.xlsx
    10 KB · Views: 4
In the attached, in cell P1 is the path to the report.xls files. You need to adjust this cell to where your report files are to be found.
There's a Power Query table at cell A5 which will only take files ending in .xls and and files beginning report (case insensitive) in that folder.
You then need to update the table at cell A5 by right-clicking somewhere in the table and choosing Refresh. That's it.
 

Attachments

  • Chandoo47884Sample File.xlsx
    300.3 KB · Views: 3
p45cal said:
In the attached, in cell P1 is the path to the report.xls files. You need to adjust this cell to where your report files are to be found.
There's a Power Query table at cell A5 which will only take files ending in .xls and and files beginning report (case insensitive) in that folder.
You then need to update the table at cell A5 by right-clicking somewhere in the table and choosing Refresh. That's it.
Click to expand...
Thank you very much sir problem solved
 
You must log in or register to reply here.
Back
Top