Ellendigitl00
New Member
- Joined
- Oct 23, 2024
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hello all,
I have an Excel file with 12 sheets, representing 12 months of a year ("JAN", "FEV", "MAR", etc). In each sheet I have 3 tables.
I also have a cell with Data Validation with the names of the sheets.
I want to change dynamically the Source of PowerQuery based on the selection of the Data Validation.
Basically if I choose "JAN" on Data Validation, the Query should go to that Sheet and upload the 3 tables of Sheet.
To do that I know I should change some sort of code in Advanced Editor, but Excel programming isn't quite easy to me....
If anyone could help, I appreciate it.
Thanks in advance!
I have an Excel file with 12 sheets, representing 12 months of a year ("JAN", "FEV", "MAR", etc). In each sheet I have 3 tables.
I also have a cell with Data Validation with the names of the sheets.
I want to change dynamically the Source of PowerQuery based on the selection of the Data Validation.
Basically if I choose "JAN" on Data Validation, the Query should go to that Sheet and upload the 3 tables of Sheet.
To do that I know I should change some sort of code in Advanced Editor, but Excel programming isn't quite easy to me....
If anyone could help, I appreciate it.
Thanks in advance!