| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select a worksheet
I'm using the below formula to determine the specific type of equipment from
a list named: database =IF(VLOOKUP($J$2,Database!$A:$U,21,FALSE)=$X$2,"De sktop",IF(VLOOKUP($J$2,Database!$A:$U,21,FALSE)=$X $5,"Notebook","Error!!!!!!!")) value of X2 = DSK and value of X5 = NBK What I need help with is a way of using the value returned to automatically open the relevant worksheet, ie: If "Desktop" is returned the Desktop worksheet needs to open and if "Notebook" is returned the notebook worksheet needs to open automatically. All worksheets are in the same workbook. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Indirect to Select Worksheet | Excel Worksheet Functions | |||
| Can I create a worksheet menu to select each other worksheet | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| select worksheet to run macro | Excel Discussion (Misc queries) | |||
Threaded Mode
