Macro to open worksheet based on name in cell

  • Thread starter Thread starter Sunnyskies
  • Start date Start date
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.
 
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
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Excel Vlookup formula based on cell data 7
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Duplicating worksheet based on range and changing worksheet name 3
Excel Macro to hyperlink an archived worksheet to an index page 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top