Results 1 to 2 of 2

Validation List to Grow with Entries?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Validation List to Grow with Entries?

    Hi, Not sure how to work the title, but I'm wondering if you can somehow create a list that lets you enter new items or pick from the existing items -

    For example, Column I will have the name of an insurance company for each client

    There are 2000 rows of clients

    I want to enter any new insurance companies in Col. I or pick from the existing ones in Col. I to eliminate typos

    (there might be blanks between what was entered and new items, so the auto-type may not work)

    Not sure if this is worksheet or VBA function

    Thanks!
    Last edited by ker9; 11-11-2010 at 10:06 AM.

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