Strange-Asparagus540 has asked a question that gets to the heart of what modern data work should feel like: *Can I run two queries in one workbook on different sheets?* The answer is yes, and the real story is why that matters. This user already has a system pulling YTD spend from a server folder with a single click. That is a solid foundation. But they want more, they want to see weekly burn by department, comparing the latest data against the previous period to track momentum. That is a shift from static reporting to dynamic analysis. It is exactly the kind of move that turns a spreadsheet from a record of the past into a tool for understanding the present.
The practical path is straightforward. A second query can pull the newest week's data into a third sheet. A third query, or a simple formula, can compare the two sets to calculate the difference. That difference is the burn. It reveals which departments are accelerating, which are slowing, and where attention is needed. The user does not need to rebuild their process. They need to extend it. And the workbook can handle multiple queries on multiple pages without conflict. Each query lives on its own sheet, refreshing independently, respecting the folder structure and the server path already in place. The complexity is in the logic of what to compare, not in the tool itself.
This is where an AI-native approach changes the experience. A traditional spreadsheet would require the user to manually align columns, write VLOOKUPs, or copy-paste data across sheets, each step introducing risk of error. An AI-powered workbook can interpret the user's intent: *show me the difference between last week and this week for each department.* It can suggest the comparison, build the query, and present the result without the user needing to script every step. The human focus stays on interpretation and action, not on wiring up formulas. That is the transformation worth exploring.
For anyone managing departmental spend week over week, the takeaway is this: you do not have to choose between simplicity and depth. Multiple queries in one workbook are not a workaround; they are a design pattern. They let you keep your source data clean while building the views that answer your real questions. Set up the second query. Compare the weeks. Let the tool do the repetition so you can do the thinking.