Manny_Avila
New member
- Joined
- Apr 21, 2020
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- MS Office 365
Hi,
Looking for help in creating a simple straight line depreciation schedule. Highlighted in yellow in the attached file is an area that I need to population based on the asset item in the header row. The table returns the total depreciation for the item, per year.
The dataset in the left table contains the info pertaining to the asset and it's depreciation info.
I've manually gone thru and populated each item with the value that pertains to the year and item. I'd like to have a formula created that will populate the table automatically.
Thanks in advance
-Manny
Looking for help in creating a simple straight line depreciation schedule. Highlighted in yellow in the attached file is an area that I need to population based on the asset item in the header row. The table returns the total depreciation for the item, per year.
The dataset in the left table contains the info pertaining to the asset and it's depreciation info.
I've manually gone thru and populated each item with the value that pertains to the year and item. I'd like to have a formula created that will populate the table automatically.
Thanks in advance
-Manny