EXCEL Spreadsheet calculator

Occasional Contributor

I have a worksheet calculator where I enter a stock name in A1, and it gives back the calculation output to me in A2 (It involved using stockhistory() to get data online and it loads about 10 seconds to have result) 


On another spreadsheet, I have a list of stock on Column A and I want to use the above calculator to get the output on Column B. How should I do that? 


1 Reply