Date/Time: Fri, 02 Jun 2023 15:32:04 +0000
Post From: Backadjusting spreadsheet database
|vegasfoster - Posts: 444|
Sorry, got obsessed with my own thing. So, couple questions. Are you updating this daily? Is this already backadjusted and you just want to be able to update going forward?
My initial concept was to create a macro that will update the prices based upon a figure you enter. Right now I have it set so that you enter the amount of the adjustment in cell T8, then click the "Adjust Prices" button, select the range you want to adjust, click ok. You can select ranges on other sheets and it will automatically return to the "m5 stats" worksheet so you can do it all over again. If you are going to be adding/deleting sheets and or making other changes to where the data is located, then something like this is the best option. If you get everything to the point where you aren't making any more changes, then I can make it so it updates the entire workbook all at once.
Date Time Of Last Edit: 2014-02-12 15:08:54
Swing range stats draft1.xlsm - Attached On 2014-02-12 15:07:40 UTC - Size: 2.09 MB - 347 views