Microsoft Excel Programming

Associate
Joined
24 Apr 2006
Posts
148
I have created a financial spreadsheet for myself that runs into the future and i need some help setting it up, some of the columns are as follows...

Date ...... Balance ......

Which run from the present day to a couple of years ahead of today, i need a forumla to put in a box at the top of the page 'current balance' so i need it to pick out todays date from date column, then the appropriate balance it it's row.

All help appreciated. Cheers
 
Brains said:
Excellent - Thankyou.

When copying cell forumlas down, how do you fix one entry, so...

A1 = B1 + C1
A2 = B2 + C1
A3 = B3 + C1

As opposed to...

A1 = B1 + C1
A2 = B2 + C2
A3 = B3 + C3

Cheers.
 
Back
Top Bottom