Forum Discussion

Eric9919's avatar
Eric9919
Copper Contributor
Jul 06, 2022

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 STOCKHISTORY formula but won't run the formula. I have to go to each sheet click STOCKHISTORY to get updates for each ticker. Any way to automate the update on each sheet?

Thanks

excel

8 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 06, 2022

    Eric9919 

    Do you mean within STOCKHISTORY formula you have the reference on the cell with date in another sheet?

    • Eric9919's avatar
      Eric9919
      Copper Contributor
      Jul 06, 2022

      SergeiBaklan yes, the idea is when i change the current, all the sheets will be updated to the latest history

       

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jul 06, 2022

        Eric9919 

        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.

Resources