Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query
Is there any way to accomplish the following?
I have a workbook containing multiple worksheets. Col A in all worksheets contains a series of numbers that are unique: Wksht 1 Wksht 2 Col A Col A 126345 995346 678910 798394 How can I get Excel to prompt the user for a # in Col A and, based on a match, open JUST that worksheet. Thanks for any/all help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |