MS query criteria - referencing a cell on a spreadsheet
 

Hi Folks - my first ever posting here. I'm sure this has come up and been
answered before, but I could not find it when I searched.

I have 3 sheets in a workbook... I want to have a results sheet an input
sheet and a formatted output sheet. In Query, I want it to read the value in
a cell and use it in the criteria. I know how to do a parameter, but I do
not know how to tell Query to use a cell in on the Input sheet, as the value
for the criteria. I tried "=Inputs!C2" but that did not work.

Certainly this is an easy thing to do. Please advise what my format should
be for this query to return values based on a cell.
Thanks.

MS query criteria - referencing a cell on a spreadsheet
 

Adam

I think *it is* a parameter query you want? Take a look here

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

(near the bottom)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"Adam" wrote in message
...
Hi Folks - my first ever posting here. I'm sure this has come up and been
answered before, but I could not find it when I searched.

I have 3 sheets in a workbook... I want to have a results sheet an input
sheet and a formatted output sheet. In Query, I want it to read the value
in
a cell and use it in the criteria. I know how to do a parameter, but I do
not know how to tell Query to use a cell in on the Input sheet, as the
value
for the criteria. I tried "=Inputs!C2" but that did not work.

Certainly this is an easy thing to do. Please advise what my format
should
be for this query to return values based on a cell.
Thanks.