Results 1 to 8 of 8

Compacting List for Drop Downs

Threaded View

  1. 06-20-2023, 08:22 AM #1
    mycon73
    mycon73 is offline
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,054

    Thumbs up Compacting List for Drop Downs

    Hi Group

    I have 2 small table of products with blank rows or cells between tables.


    I want to take this list and compact it for drop down cell options in another section of document.

    How to compact tables - See example?
    Attached Files Attached Files
    Last edited by mycon73; 06-21-2023 at 09:20 PM.
    MyCon
    -- Using Latest Version of Excel
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dependent drop down list: 2 different drop downs depending on 1 drop down
    By DeepakAsks in forum Excel General
    Replies: 6
    Last Post: 01-07-2021, 12:05 PM
  2. [SOLVED] Excel Drop Downs From List on Different Sheet example...
    By feroz763 in forum Excel General
    Replies: 3
    Last Post: 11-13-2019, 12:11 AM
  3. Drop Down list dependent on 2 previous drop downs
    By mrkawht in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-16-2018, 02:39 PM
  4. Using multiple drop-downs to filter list to produce final unique list
    By goldyc87 in forum Excel General
    Replies: 5
    Last Post: 03-02-2015, 02:32 PM
  5. Lists/drop downs creating more than one sub list?
    By Zhola in forum Excel General
    Replies: 6
    Last Post: 10-31-2007, 01:12 PM
  6. Drop Downs within a Drop Down List
    By rco@railpower in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2007, 07:30 PM
  7. list added to list using drop-downs
    By karambos in forum Excel General
    Replies: 0
    Last Post: 04-27-2005, 07:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1