Forum Discussion

Cyiin's avatar
Cyiin
Advocate I
3 years ago
Solved

Combining multiple sheets (but not all) from multiple Excel files in a Sharepoint folder

Hi!   I have a Sharepoint folder of monthly reports. Each report has more than 10 sheets, but I only need to get the data from 5 specific sheets (some of the files may not have all of those 5 sheet...
Need Help
  • edhans's avatar
    edhans
    3 years ago

    Filter the files you want to expand and click the Expand icon. You should get this:

     

    Click on the Parameter folder, not any sheet tabs

    The next screen will look similar to this:

    Filter the KIND column to only show Sheet if that is what you want.

    Then filter the Name column to only show the 5 that you want. If one workbook only has 4, it won't matter.

    Then click the Expand icon by the data column.

     

    This will expand all 5 sheets (or as many as is available) in all files, but will ignore the sheets you do not want.

edhans's avatar
edhans
Community Champion
3 years ago

Filter the files you want to expand and click the Expand icon. You should get this:

 

Click on the Parameter folder, not any sheet tabs

The next screen will look similar to this:

Filter the KIND column to only show Sheet if that is what you want.

Then filter the Name column to only show the 5 that you want. If one workbook only has 4, it won't matter.

Then click the Expand icon by the data column.

 

This will expand all 5 sheets (or as many as is available) in all files, but will ignore the sheets you do not want.