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

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.
 
Y

ykontou

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating A List of Items Between Two Numbers 2
Cash Flows Inflation Adjusted 2
How to distribute/spread/map cost of project across different year 3
Need To Complete Formular To Sort And Show Frequency 2
Sequencing of projects 1
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1
Sorting Data Advice please 2
Business working days & Cash FLow 2

Top