Forum Discussion

Chris525's avatar
Chris525
Copper Contributor
May 20, 2024
Solved

Merge Excel workbooks and create a summary

HI All,   Looking for merging the excel files for different vendors and create one summary file.   I have 30 different excel files with the same format and want to merge a small portion (Highligh...
excel
Macros and VBA
  • Lorenzo's avatar
    Lorenzo
    May 21, 2024

    Hi Chris525 

    You're welcome. Glad I could help

    When you have a minute could you click on Mark as response (at the bottom of each reply you get here) to help people who Search - Thanks

Lorenzo's avatar
Lorenzo
Silver Contributor
May 20, 2024

Hi Chris525 

 

For this kind of things it's better to share a sample file as it's not clear if the info. you want to extract is in the first 7 rows. Assuming it's in the first 7 rows of each 'Sheet1':

  1. Store your 30 files in a folder
  2. Download & open the attached file
  3. In sheet PARAM replace 'C:\Lz\Downloads...' with the path to the folder containing your 30 files
  4. Switch to sheet Summary
  5. Right-click in the blue table > Refresh

Resources