+ Reply to Thread
Results 1 to 2 of 2

Using lists - is this possible?

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Question Using lists - is this possible?

    So I've tried searching for this but I am not sure what to write as a search description.

    Basically this is the scenario I've got a stocks and shares spreadsheet. Column A has the stock tickers and the other columns use vlookups to another sheet which is a giant data dump page to pull through things like debt, sales, earnings growth etc but in a more presentable fashion.

    At present I've got a separate sheet for each ticker list, i.e. S&P 500, FTSE 100 etc. What I'd like to do is just have one sheet with a drop down box at the top of the sheet that selects the index and then populates the column below with the stock tickers for that index. I should also add that both the data dump and the nice tidy sheet are set up as tables. The other thing is, as you may have guessed is that one list is 500 long and the other only 100 so is it possible to automatically resize the table depending which list you choose?

    Many thanks in advance.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365

    Re: Using lists - is this possible?

    This doesn't sound too difficult especially if we use some clever naming conventions for the tables. However, it would help a lot to see how the data are organized. Could you provide a sample workbook? It can definitely be done with VBA. There may also be a possible solution using INDIRECT and / or Array functions.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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] data validation lists - drop down lists too small
    By reglook0736 in forum Excel General
    Replies: 3
    Last Post: 04-24-2015, 12:49 PM
  2. Replies: 1
    Last Post: 07-27-2014, 10:23 AM
  3. [SOLVED] Add or remove info to two lists in Sheet1 and Sheet2 and difference between two lists
    By alipezu in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-01-2014, 12:28 AM
  4. Dependent drop down lists without creating unique named lists
    By pajordan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 12:20 PM
  5. Validation Lists - Multiple dependent lists with unique values
    By Lewigi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 06:42 AM
  6. Replies: 1
    Last Post: 06-14-2013, 04:06 PM
  7. how to ignore blank cells in creatig dropdown lists (validation lists)
    By Elainefish in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-02-2013, 07:45 AM

Tags for this Thread


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