I have a very lengthy and, what I think is, a very complicated Excel question:
I'm working in Excel 2003, I'm looking at inventory depreciation forecasts between two different sheets. The two sheets are entitled '2002-Present' and 'Present-Forecast'. The reason I'm using two sheets is because I can't move beyond Column IV in Excel 2003, so I have to use another sheet in order to forecast far enough into the future.
I have the columns "Depr", "Accum Depr", and "Book" for EACH MONTH. So, I have those three columns for January 2009, February 2009, etc, all the way into the far future. All of my inventory entries are contained in the rows. The other columns I have associated with each inventory entry are "Cost", "Date Entered", and "Time to Depr", but those are only entered once (for the first date the entry is catalogued).
My problem, for now, is one-fold (though I might add to it later):
1) I need to be able to lock the depreciation data associated with each individual entry so that new entries can be added, but the old entries will still be properly aligned with the correct data. AND, I need to make sure that when a new entry is added to '2002-Present', it is also added to 'Present-Forecast'... Fairly complicated (at least for me).
Any help is much appreciated. Thanks!
I'm working in Excel 2003, I'm looking at inventory depreciation forecasts between two different sheets. The two sheets are entitled '2002-Present' and 'Present-Forecast'. The reason I'm using two sheets is because I can't move beyond Column IV in Excel 2003, so I have to use another sheet in order to forecast far enough into the future.
I have the columns "Depr", "Accum Depr", and "Book" for EACH MONTH. So, I have those three columns for January 2009, February 2009, etc, all the way into the far future. All of my inventory entries are contained in the rows. The other columns I have associated with each inventory entry are "Cost", "Date Entered", and "Time to Depr", but those are only entered once (for the first date the entry is catalogued).
My problem, for now, is one-fold (though I might add to it later):
1) I need to be able to lock the depreciation data associated with each individual entry so that new entries can be added, but the old entries will still be properly aligned with the correct data. AND, I need to make sure that when a new entry is added to '2002-Present', it is also added to 'Present-Forecast'... Fairly complicated (at least for me).
Any help is much appreciated. Thanks!
