August 10, 2022
I have 10 workbooks that each contain the following sheets: Yearly total and each month of the year
I have successfully used PQ to total the Yearly and April from each of the ten work sheets but when I go to move onto May and I want to switch to the next table name (all Mays are names the same Table 719, June shares its table name with all ten workbooks etc) it gives me the same query or an error when I try to change the table name in the sample. I don't know how to change the table names so in my new summary work book the tabs for the sheets have a Dashboard, a data tab, Yearly total and a tab for each month. I am stuck. I can find lots of videos to get the summary but none on how to keep using the query to get different data summed.
Please help! I am on a deadline and I can't create the dashboard without the monthly data.
July 16, 2010
Welcome to our forum!
In the query editor Home tab go to Data Source Settings and 'change source' to point to the folder containing June's files.
Then you'll need to go to the query called 'Transform Sample File' and go to the navigation step and edit the table name being referenced in the formula bar or by clicking on the cog icon in the Applied Steps pane.
Hope that helps.