Forum Discussion
Eric9919
Jul 06, 2022Copper Contributor
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...
SergeiBaklan
Jul 06, 2022Diamond Contributor
Do you mean within STOCKHISTORY formula you have the reference on the cell with date in another sheet?
- Eric9919Jul 06, 2022Copper Contributor
SergeiBaklan yes, the idea is when i change the current, all the sheets will be updated to the latest history
- SergeiBaklanJul 06, 2022Diamond Contributor
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.
- Eric9919Jul 06, 2022Copper Contributori believe the STOCKHISTORY cell formula got updated, but the sheet won't get updated until i manually go click each STOCKHISTORY cell and execute.