Forum Discussion

Manimalinc's avatar
Manimalinc
Frequent Visitor
3 years ago
Solved

get data from multiple Excel sheets in one file hosted in Sharepoint

Hi Everyone   I hope you can help me here   so I have an excel file multilple worksheets( Matt, Anna, Carsten ,Dimitry etc etc )  and  all same data format   (person,date,booking Type,Product,Cus...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    Note that you also could have just clicked on the "Binay" hyperlink to drill into the Excel workbook (and not create all the extra stuff that comes from the Combine & Transform functionality.

     

    Pat

Manimalinc's avatar
Manimalinc
Frequent Visitor
3 years ago

Hi Pat 

 

Thanks but my issue is once I have filtered on the specific file, I do not seem to have the option to "filter" again on "sheets".