Trying to create a flexible number of years to project cash flows

  • Thread starter Thread starter Arvi Laanemets
  • Start date Start date
A

Arvi Laanemets

Hi

Enter into some sheet the values for starting and last years
Define those cells as named ranges (Insert.Name.Define) p.e. FirstYear and
LastYear
Into cell where you want your column names (as year numbers) to start, p.e.
C1, enter the formula
=IF(FirstYear+COLUMN(C1)-COLUMN($C$1)>LastYear,"",FirstYear+COLUMN(C1)-COLUM
N($C$1))
(adjust the cell reference according your design) and copy it to right as
much as you think you need.
 
Hi
I want to define the number of years that I would like to project
cash flow and then have a cashflow sheet generate the number of year
up and until the defined number of years in seperate columns,

any ideas?
 
Back
Top