Aug 28 2021 12:39 AM - edited Aug 29 2021 03:56 AM
Sep 03 2021 11:41 AM
Solution
used Power Query on the Main Tab
Created reference queries
Renamed and filtered the reference queries according to the data filtered on them
when you update the main tab then press ctrl+alt+F5 it will refresh the master query as well as all the reference queries according to what they're filtered to
to add a new reference query:
click data then the icon in the red square to display the query navigation
double click the master query
in the queries navigation panel right click the master query then select reference
Rename the query to the data that you will filter for that reference query, then click close and load then save the file
cheers
Sep 06 2021 10:07 AM
Sep 06 2021 10:32 AM
Sep 06 2021 12:01 PM - edited Sep 06 2021 12:05 PM
it is not a dumb question, you are just communicating the area of your confusion to make a clarification and that is a best practice.
The reference queries that are named KEL30 for example is the query that will be loaded into the worksheet, as is with all the other reference queries that's why the sheet names are the same names of the reference queries.
Try it. Put new information on existing designations as well as information on new designation, then press ctrl+alt+F5, then look at the designation worksheets that you added new information, then create a new reference query for the new designation that you added for fun and for practice.
When you update the Master Sheet with new information, those existing reference queries will dynamically (automatically) update including the filtering.
If the master sheet gets updated with a new designation, for example TZZ01, you will only need to create a reference query for that particular designation and load it into worksheet in the workbook and once you save the workbook the next time you update it it will automatically update the new information to the existing reference queries and all you have to do is create a reference query to new designations that are in the master worksheet.
cheers
Sep 06 2021 03:38 PM
Sep 03 2021 11:41 AM
Solution
used Power Query on the Main Tab
Created reference queries
Renamed and filtered the reference queries according to the data filtered on them
when you update the main tab then press ctrl+alt+F5 it will refresh the master query as well as all the reference queries according to what they're filtered to
to add a new reference query:
click data then the icon in the red square to display the query navigation
double click the master query
in the queries navigation panel right click the master query then select reference
Rename the query to the data that you will filter for that reference query, then click close and load then save the file
cheers