Parameter Query in MS Excel

  • Thread starter Thread starter wotrac
  • Start date Start date
W

wotrac

Hi Folks

I am trying to create an MS excel Query which uses the cell references
in an Excel Spreadsheet.
I have no problem running the parameter query with 1 or 2 cells, but my
source spreadsheet will have a variable range of cells, greater than
30.

Could anyone tell me if there is a way to pass these cell references to
the MS query automatically, so that when the spreadsheet refreshes, the
data will be updated.

N.B. My VBA is limited
 
You would need to tell us more such as the url being used and what method of
query you are using and the part of the url that needs to be changed.
 
Back
Top