Forum Discussion

lpriceFTW's avatar
lpriceFTW
Helper II
3 years ago
Solved

Make Excel Workbook Sheet Import Dynamic

I have an M query which combines a specific sheet from multiple workbooks into one table.   The source is a folder which contains 12 Excel workbooks (one per month).   When setting up the query a...
Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    HI lpriceFTW 

     

    Why don't you filter, in the origin, the column by the values that starts with...? 

     

mlsx4's avatar
mlsx4
Memorable Member
3 years ago

HI lpriceFTW 

 

Why don't you filter, in the origin, the column by the values that starts with...? 

 

lpriceFTW's avatar
lpriceFTW
Helper II
3 years ago

Thank you! Simple and straightforward.