Solved

I need to find a specific worksheet in a spreadsheet.

Posted on 2014-12-07
4
72 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

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Viewers will learn the different options available in the Backstage view in Excel 2013.
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…

707 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