Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2001
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filter Info on Summary Tab (2003)

    I will have around 30 tabs for all individuals in a company. Each tab will list all dates of training/certificates each individual has taken, whether it needs to be renewed yearly, bi-yearly, or tri-yearly, and what date it expires. On a summary tab, I need Excel to go through all of the tabs and pull together all the training that needs to be completed for the current year.

    For example, if five people have a CPR certification that expires on June 1, 2005, Aug. 10, 2005, & Dec. 31, 2005, I need the summary page to:

    1. List each person's name (always in cell A1 on all tabs)
    2. The training/certificates that needs renewed (always in column B on each tab and the same row as the expiration date)
    3. Expiration date (always in column G on each tab and the same row as the class/certificaiton)

    Of course the listing of each CPR certification could be on different rows on each tab. Anyone have any ideas?

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filter Info on Summary Tab (2003)

    Dawn,

    Would it not be easier to keep track of eveyone in one sheet? In having everyone in one sheet you could use "advance filter" settings to select various dates, certifications and etc.

    John

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filter Info on Summary Tab (2003)

    I agree with John that if this was all on one sheet, then what you want could probably be done using standard tool like Advanced Filter. With the data on separate sheets it is probably going to take VBA code. If you want to do it with VBA, then we will need a workbook to test the code with. You will need to upload a workbook with any confidential data change.
    Legare Coleman

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Filter Info on Summary Tab (2003)

    I also concur with John and Legare's suggestion of one sheet.

    In addition to adv filter, autofilter could be used and even pivot tables to summarize the data. WIth one sheet, excel has many built-in features to summarize and work with the data without having to use VBA to code it.

    Steve

Posting Permissions

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