ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   External Database Source (https://www.excelbanter.com/excel-worksheet-functions/138666-external-database-source.html)

ericat04

External Database Source
 
I have one spreadsheet that contains 6 or 7 Queries that are all directed
toward the same data source "MB7 data - 2006". These were needed to pull
figures from last year's data. But I now need to point this entire sheet (and
all of the queries) in the direction of this year's data..."MB7 data". Is
there any way to redirect these queries toward a different data source or
maybe copy them into a new query that points towards the current year's data?


All times are GMT +1. The time now is 04:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com