+ Reply to Thread
Results 1 to 1 of 1

adding to a filtered list

  1. #1
    Registered User
    Join Date
    12-19-2021
    Location
    iowa
    MS-Off Ver
    2007
    Posts
    3

    adding to a filtered list

    I have a workbook, in Office 2007, to keep track of NASCAR driver’s records. This workbook was made for me by a now deceased friend that obviously can’t help me with it. There is a sheet for every driver. The last sheet, named Stats, is set up with 2 drop down filtered lists. One to select the drivers and one for the track that you want to show their results for. I want to add some new tracks to each of the driver’s sheets. That I know how to do but I can’t get the new tracks to show in the track drop down. If I change the name of one of the existing tracks, it will show up in the list but the original does not. Searching online for helpful articles, I found how to show the name manager. One of the formulas listed is called track_list. It’s value is {“”;””;””;””;””;””;””;””;””;””;””;””;””;””;””;””;””;””;””;””;””;””;} It refers to
    =Stats!$AA$2:$AA$23
    There is no data in that cell. I do not know how to program anything in Excel but my best guess is that if I could add to the track_list value, more of the double quotes, it would pull in more track names for my list?

    I have attached this workbook and I will thank you ahead of time for trying to help me with this issue.
    Attached Files Attached Files

+ 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. [SOLVED] Count Values in Filtered List / Return Final Row in a Filtered List
    By HarryGreenwood in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-22-2018, 06:52 AM
  2. [SOLVED] Excel VBA - Issue in Naming Filtered Range on a Filtered List.
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2014, 01:17 PM
  3. Adding different filtered columns
    By dupperco in forum Excel General
    Replies: 3
    Last Post: 06-24-2009, 03:21 AM
  4. Adding times in a filtered list
    By ljerromes in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-29-2008, 09:26 AM
  5. Adding only the filtered results
    By spartikus411 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2006, 06:20 AM
  6. Adding only the filtered results
    By spartikus411 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2006, 06:10 AM
  7. Adding up filtered list..........only what is shown on screen?.....
    By Duncan in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-13-2006, 06:50 AM

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