ExcelBanter - External data into Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - External data into Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/262879-external-data-into-excel-2007-a.html)

Dave Mc

External data into Excel 2007

I have a workbook with several sheets with a query attached which prompts for
a parameter. Each shhet gets a different value for the one parameter. My
problem is, when I run the query, no matter which sheet I'm on, the data gets
returned to sheet one. What am I doing wrong ?

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