Microsoft Excel Programming

Brains

Brains

Brains

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
 
Heres a rather simple way of doing this mate.

Insert '=TODAY()' into say C:3, this will then always show as todays date when you open the file. You then want to do a vlookup for this date on the data you are holding so . . . .

Lets say your date and balance information runs from A:5 to B:35 the formula would look like this.

=VLOOKUP(C3,A5:B35,2,FALSE)

This would then look for todays date in for date fields then when it finds it will bring back the balance which is next to that date.

Hope this makes sense!! :D
 
Brains said:
Excellent - Thankyou.
Click to expand...

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.
 
You need to make it an absolute reference, click the cursor onto the c1 cell reference in the formula bar then press F4 until it reads $C$1 then it will always go to that cell when you copy the formula
 
He speaks the truth, sorry i missed that bit out, its funny what you miss out when your so used to doing something.

:o
 
You must log in or register to reply here.
Back
Top Bottom