Macro to open worksheet based on name in cell

S

Sunnyskies

Afternoon from Sunny RSA,

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.

Your feedback will be appreciated.
 
D

Douglas J. Steele

Sorry, but this newsgroup is intended for questions about Access, the
database product that's part of Office Professional.

Your question would be best reposted to a newsgroup related to Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to open worksheet based on name in cell 5
Excel Excel Vlookup formula based on cell data 7
MATCH, Vlookup whatever 3
SUMIF and SUMPRODUCT with INDIRECT formula problem 1
Duplicating worksheet based on range and changing worksheet name 3
Auto worksheet name? 1
nameing a worksheet 1
Creating range name based on cell value. 6

Top