Matching value of a cell to a sheet name

N

NathanG

I need to match a value in a cell that the user selects from a combo box
using data validation that would then go to the sheet associated with the
selection.

The user is selecting a job to look up. When a new job is created the sheet
is copied and the job name becomes the sheet name i.e. jobname = job1
(sheet1 = job1). This will happen every time a new job is created. The job
name is copied to a different sheet where the data validation looks it up as
a job. I would like a command button with code that looks up the job,
matched it to the sheet name and then goes to that sheet. For example

Job = Job1. Click "find job" and the job detail appear.

Any thoughts? I have thought about v lookup but I'm sure it will work. The
maxium amount of jobs is 20 at the moment for development purposes.

Thanks

Nathan
 
T

Tom Ogilvy

worksheets(Worksheets("Entry").Range("A1").Value).Select

Where
Worksheets("Entry").Range("A1").Value
contains the name of the sheet you want to go to (the sheet that has the
data validation combobox).
 

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

Top