Updating data by changing date

[tara_922]

Hiya all!

I don't even know where to start and think I may possibly need to write code for this to work.

Basically, I am working on a depreciation sheet. I want to have the date be able to change and with it update some of the data in the sheet.

The data I have is the acquisition date, the life expectancy of the product, the initial cost, the total depreciation (from purchase to present date), the YTD depreciation, the MTD depreciation, and the Book Value (=the initial cost - total depreciation). There are 10 total items that are depreciating. I obviously have a grand total column as well.

Ideally, I would like to just change the date at the top and have that change the total depreciation column, the YTD depreciation column and the Book Value column. All by adding or subtracting one months depreciation.

Is this possible? How would i go about it?

Thanks a bunch,
Tara

 

[Biz]

Hiya Biz!

Working perfectly thanks! Sorry it's taken a couple days to get back to you just had to update all of 60+ cells one by one for several fields. Dragging didn't work.

Thanks again!

Tara

Nice to hear it solves your problem.

Biz