I have a ss with multiple tabs, formulas & contingencies all building a price. I would like for there to be a history of those prices so I can add some more contingencies.
Right now a download builds a price. That price is built in this example on the "example" tab shown. I would like for that price to then be transferred, copied into the "history input" tab. I can make it do that but only for one day. Each day the price changes, all the days prices change to today's on the "history" tab.
I need for a formula or some direction that will allow the data to roll to the formula to roll to the next day without compromising the previous day and so on.
I have attached a crude example ss for anyone to play with. Let me know if you need anything else. Thank you in advance.
Bookmarks