Solved

I need to find a specific worksheet in a spreadsheet.

Posted on 2014-12-07
4
70 Views
Last Modified: 2014-12-08
I have a spreadsheet with hundreds of worksheets named something like
Contract566, Contract630, Contract 912.
I can't seem to easily find a specific worksheet, except by scrolling through them.  Surely surely not!
0
Comment
Question by:kerikeri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
10023 earned 500 total points
ID: 40486114
I don't have 2010 anymore but do you have this feature in 2013...to the right of the sheet tabs click or right click to get an activation dialog box...see snip
activate
0
 
LVL 24

Expert Comment

by:NVIT
ID: 40486116
You might have to make a macro that ask for the worksheet name, then takes you there:
Sub GotoSheet()
    Dim sSheet As String

    sSheet = InputBox( _
      Prompt:="Sheet name or number?", _
      Title:="Input Sheet")
    On Error Resume Next
    If Val(sSheet) > 0 Then
        Worksheets(Val(sSheet)).Activate
    Else
        Worksheets(sSheet).Activate
    End If
End Sub

Open in new window


http://excel.tips.net/T003119_Jumping_to_a_Specific_Worksheet.html

Even then, IDK if that's fast enough because you'd have to type the entire name. What's faster - that or scrolling? 8-)

With your worksheet naming scheme, maybe revise the code so you just have to type the number. Like:
    sSheet = InputBox( _
      Prompt:="Sheet number?", _
      Title:="Input Sheet")
    sSheet = "Contract" & sSheet

Open in new window


Then, the macro puts the "Contract" prefix for you.

Note: I haven't tested it. And it may not be the best way to do it.
0
 

Author Closing Comment

by:kerikeri
ID: 40487458
Perfect, and so simple.  Thank you.
0
 
LVL 10

Expert Comment

by:10023
ID: 40488180
Your welcome
stephen
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question