Repeat Row Based on Standard Life of Item for X Times Until End of Period

Hello again everyone!


You all have been so helpful, and thought I would come here to ask a few last questions. I received some help to set up my excel file magnificently before, and thought I understood what went on to get to that point (well I kind of). Unfortunately, I couldn't adjust the code a small amount to get where I want to go.

In the attache excel file, I have the first tap noting the current year and how many years to analyze.

The next tab has a line item number, two descriptions, and then the magic love: the expected lifetime of the item, a cost, when the item was first used, any adjustments to the current expected lifetime of the item, and then automatically calculating the remaining life based on adjustments and the next renewal year.

The next tab, wonderfully outlines all the costs by date.- Seriously, it's beautiful- but lacks one thing.

I need help from anyone who can understand the code used to ensure that items which need to be repeated, are repeated. For example, Item 10 will expire in 2014, but then again will be implemented using the standard life (5), and again will expire in 2019. This re-implementation does not currently show in the expenditures tab for 2019. Items which have expires within the analysis period will need to be implemented again until the end of the analysis period.

Help Sample.xlsm

Can anyone provide me with some help? I've spent pretty much all of my morning trying to figure out how to accomplish this.

Much appreciated to anyone who can provide some aid.

Cheers

JRUB