+ Reply to Thread
Results 1 to 10 of 10

Large number of worksheets

Hybrid View

  1. #1
    Registered User
    Join Date
    10-14-2010
    Location
    BC Canada
    MS-Off Ver
    Excel 365
    Posts
    78

    Large number of worksheets

    I started a while ago developing an excel workbook for projects. Worked well for smaller projects but now I'm faced with a larger sized job and I figure I'll be around 160 work sheets. Navigating with the small ribbon at the bottom isn't going to work. I am out of luck? Is there a better way to navigate workbooks with a large number of sheets?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Large number of worksheets

    What is the actual need of 160+ worksheets instead of keeping a single worksheet to store all the master data?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    10-14-2010
    Location
    BC Canada
    MS-Off Ver
    Excel 365
    Posts
    78

    Re: Large number of worksheets

    There is basically one sheet that holds the data, then the rest extract from this and put it in an organized format. Each sheet represents a piece of equipment

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,941

    Re: Large number of worksheets

    you can do with a macro
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Large number of worksheets

    I would have a master sheet and a single organized format sheet, with a Data validation dropdown to extract data for each piece of equipment. Two tabs, same result.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  6. #6
    Registered User
    Join Date
    10-14-2010
    Location
    BC Canada
    MS-Off Ver
    Excel 365
    Posts
    78

    Re: Large number of worksheets

    Quote Originally Posted by Speshul View Post
    I would have a master sheet and a single organized format sheet, with a Data validation dropdown to extract data for each piece of equipment. Two tabs, same result.
    Would I be able to print out each one? Attached is an example of what it looks like. This is for equipment being installed in a building, I end up giving it to some guys who use it to check off that everything has been done correctly.
    Attached Files Attached Files

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Large number of worksheets

    Make use of Pivot Table

  8. #8
    Registered User
    Join Date
    10-14-2010
    Location
    BC Canada
    MS-Off Ver
    Excel 365
    Posts
    78

    Re: Large number of worksheets

    Thanks Sixthsense, thanks Speshul. I'll go see if I can figure that out.

  9. #9
    Registered User
    Join Date
    10-14-2010
    Location
    BC Canada
    MS-Off Ver
    Excel 365
    Posts
    78

    Re: Large number of worksheets

    Bump.

    Possible to have it print out each version of the sheet. I guess that would be a macro job.
    Do newer versions of word have a better work sheet manager, not the small ribbon along the bottom?

    Thanks

  10. #10
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Large number of worksheets

    You could have an INDEX worksheets with hyperlinks that you just click on to take you to the worksheet that you want.

    A
    1
    POINTS!Extract
    2
    A1Z101!Print_Area
    3
    A1Z102!Print_Area
    4
    A1Z104!Print_Area
    5
    A1Z105!Print_Area
    6
    A1Z106!Print_Area
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Fast switching between large number of worksheets
    By dilipandey in forum Excel Tips
    Replies: 0
    Last Post: 07-20-2012, 01:31 AM
  2. Large Form Help: Handling large number of text boxes and labels
    By laterdaysluke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2010, 03:12 PM
  3. Data sorting over a large number of worksheets
    By xlsuser42 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2006, 02:45 PM
  4. Sorting large worksheets
    By Desmonda in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-10-2006, 08:30 AM
  5. Replies: 1
    Last Post: 03-01-2006, 02:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1