Forum Discussion
Query does not return expected results when I refresh external data
littlevillage Thanks! But I am still not sure about what you want to do. It seems you want to compare/summarize the totals in column D for each person, day-by-day. Perhaps the query and pivot table do just that. If not, please create a small example of what the result should look like.
Obviously, you need to change the source so that it points to the file on your owns system.
I am sorry for my ideas not clearly
Daily, I will get a file that's statistic how many shipper per day. The File combine many sheets.
For example, today is day 14, it will contain 14 sheets. And I am trying to create a query to return just values of day 14. And another Query will return total value of 14 days.
And when day 15 coming up, I just press refresh to change the result
I hope to can use the input file as extenal data
I upload it below
Hope for your response
Thank you
littlevillage Thanks! But I am still not sure about what you want to do. It seems you want to compare/summarize the totals in column D for each person, day-by-day. Perhaps the query and pivot table do just that. If not, please create a small example of what the result should look like.
Obviously, you need to change the source so that it points to the file on your owns system.