Forum Discussion

klausvm's avatar
klausvm
Frequent Visitor
5 years ago

Filter multiple sheets with different data by the filename

Hi there   I'm wondering if its possible to load a bunch of Excel files from a folder and filter them by the date created (or the date thats part of the file name).   All the Excel files are the ...
Need Help
Fowmy's avatar
Fowmy
Super User
5 years ago

klausvm 

 

Would it be possible for you to create 2 excel files with simple sample data and show the expected results on a different file?

 

you can share the files link here after saving them in a cloud space like OneDrive. 

 

klausvm's avatar
klausvm
Frequent Visitor
5 years ago

Fowmy 

Did you get a chance to take a look?

 

Thank you in advance

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    klausvm 

    The files you have shared cannot be downloaded, the link expired.


    • klausvm's avatar
      klausvm
      Frequent Visitor
      5 years ago

      Fowmy Did you get a chance to look at the files?

       

      I would love to be able to filter on the filename, because all of the sheets in the files are different formatting.