Excel select 1

[Cpreston]

Hi

I have an excel sheet that is linked to our SQL server to a table.

It brings in the data no problem. however what I would like it to do is ask for an order number and then just display the rows that this order number
is in.
I could filter but the table is quite big so it would be easier to prompt for the number.
We link directly into the SQL as windows user authentication, so do not want to use Msquery.

is there a simplistic way to do this in excel without VB coding at all

Thanks

 

[SkipVought]

Hi,

So on another sheet use MS Query to query the data on the sheet linked to your SQL Server data, using a parameter query that takes data from the cell that the user will fill with the OrderID.

 

[Cpreston]

I just tried and it keeps saying this data source contains no visible tables, when I link the MS Query connection on sheet 2.

The main sheet is set as a table as far as I can see

Thanks

 

[SkipVought]

In the Add Tables window of MS Query, click the Options button and check ALL boxes.

Your [Sheet Name$] will appear as table names.

 

[Cpreston]

Hi

Yes that worked thank you very much

 

[SkipVought]

Great! Hope it all works for you.