Forum Discussion
how to auto update STOCKHISTORY on multiple sheets?
Hi Insiders, I'm trying to use STOCKHISTORY for different stock on different sheet, and get ticker and date from a single "home" sheet. When I change the date on "home" sheet, it updates the STOCKHI...
Do you mean within STOCKHISTORY formula you have the reference on the cell with date in another sheet?
SergeiBaklan yes, the idea is when i change the current, all the sheets will be updated to the latest history
When I misunderstood what "it updates the STOCKHISTORY formula" means. With reference on another cell formula will be exactly the same if you change only the value in referenced cell.
- i believe the STOCKHISTORY cell formula got updated, but the sheet won't get updated until i manually go click each STOCKHISTORY cell and execute.
