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.
Bookmarks