Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've got an external data query that gets the value from a cell (vendor
number) and refreshes the spreadsheet. I'd really like another parameter that references a second cell but I haven't gotten this to work yet. I need the second parameter to be process level 'PSBP' or 'ZERO'. I'm adding this after the fact; the process level should really be the first parameter with the vendor number second. If you set the process level parameter to refresh automatically and then go after the specified vendor number, how do you keep the process level? When you key a different vendor number the second refresh would ignore the process level wouldn't it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Parameters wthin Query of External Data | Excel Worksheet Functions | |||
Multiple parameters in MS Query | Excel Discussion (Misc queries) | |||
Cannot get Wildcards in Parameters to work in MS Query/Excel2003 | Excel Discussion (Misc queries) | |||
Query Parameters | Excel Discussion (Misc queries) | |||
Help : Using Parameters with External Date Query | Excel Discussion (Misc queries) |