+ Reply to Thread
Results 1 to 3 of 3

Tabs always visible

  1. #1
    Registered User
    Join Date
    12-09-2010
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2007
    Posts
    23

    Tabs always visible

    I have 3 workbooks that we enter data for the business. Two are detail and one is a summary. Each worksheet in each workbook is a month. After 5 years I have 60 worksheets in each workbook.

    I have two questions
    1.) I'd like to combine all into one and have the detail sheets automatically update the summary sheet. If I do this, over time, I could end up with hundreds of tabs each representing a month. Is this a good idea?? (yes, I could auto update the summary workbook even if it was not combined)
    2.) If I combine all workbooks into a single workbook, is it possible to have the 'current' worksheets always be the first three sheets in the stack?(for lack of a better description) I'd like to do this so that the lady who enters the data each day does not have to go to 'the right' each day when entering.

    thanks in advance

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Tabs always visible

    Instead of having the tabs contain data for 1 month, you can have the tabs split up by years, if possible. That way you will have lesser tabs.

    You can have a small code that will make your current sheets the first 3, provided the code is able to identify which sheets are 'current'.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Tabs always visible

    Have all the data in one sheet then a PivotTable can be grouped by Months & Years
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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