Hi All
Admittedly it has been a long while since I looked at Google Sheets but they have obviously dropped the Data Validation, Criteria 'List from a Range' function and I don't know how to replace it.
I have a a set of cells with data eg A1-A100 on a separate sheet (sheet 2) (Stock Ticker Symbols)
On sheet 1 I want to have a cell (J1) that has a drop down menu for the Stock Ticker I want to select from sheet 2 A1-A100.
The reason I want this is that I can reference whatever has been chosen in cell J1 in another cell (K1) that I can then pull online data from Google to display a price graph (which I can get working for a single stock if I manually enter the Ticker in J1). I would just like to be able to display all the tickers in J1 and I select 1 from a list and the graph then magically appears a few seconds later
That's what I want but I'm stumped how to do it without the drop down list...
Admittedly it has been a long while since I looked at Google Sheets but they have obviously dropped the Data Validation, Criteria 'List from a Range' function and I don't know how to replace it.
I have a a set of cells with data eg A1-A100 on a separate sheet (sheet 2) (Stock Ticker Symbols)
On sheet 1 I want to have a cell (J1) that has a drop down menu for the Stock Ticker I want to select from sheet 2 A1-A100.
The reason I want this is that I can reference whatever has been chosen in cell J1 in another cell (K1) that I can then pull online data from Google to display a price graph (which I can get working for a single stock if I manually enter the Ticker in J1). I would just like to be able to display all the tickers in J1 and I select 1 from a list and the graph then magically appears a few seconds later
That's what I want but I'm stumped how to do it without the drop down list...