| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to open worksheet based on name in cell
I need a macro that will open a worksheet based on the worksheet name in a
cell. I have four worksheets:-COC, BVO, Vehicles and Reports Now on the Main sheet in cell B2 is a formula which based on criteria will vlookup either COC or BVO or Vehicle or Reports. Once the name appears in B2 I want that applicable sheet to be viewed. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy a worksheet and rename based upon text entered in 1 | Excel Discussion (Misc queries) | |||
| How to remove macro as I open worksheet? | Excel Discussion (Misc queries) | |||
| Deactivating a Forms macro button based on a worksheet condition? | Excel Discussion (Misc queries) | |||
| Help with a macro to open to a specific worksheet | Excel Worksheet Functions | |||
| How do I get my personal macro worksheet to open whenever I open . | Excel Discussion (Misc queries) | |||
Threaded Mode
