LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing a cell in the worksheet as the criteria for a form Alagra Excel Worksheet Functions 2 October 26th 09 05:26 PM
Referencing text from another cell for criteria in functions Tricia, not Patricia Excel Worksheet Functions 1 July 26th 09 01:48 AM
Excel cell contents to query criteria Jimbo Excel Discussion (Misc queries) 1 April 22nd 09 07:46 PM
Applying Criteria in Excel Cell to MS Query Pull from Access Tony Excel Discussion (Misc queries) 1 February 1st 08 04:43 PM
Using A Cell In Excel as Criteria for a Query charles Excel Discussion (Misc queries) 2 July 14th 06 05:06 PM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"