Simple formula

I am trying to set up a spread sheet that will multiply one colum by another for each row. I know I can set it up by each individual row, but I have an infinate number of rows.

Also how would I make a formula to add the last five cells?

Thanks in advanced.

[hennahairgel]

I do not understand. If you want the macro to repeat itself for the number of rows try a loop with the code
Range("a1").Select
Range(ActiveCell, ActiveCell.End(xlDown)).Select
noofrows = Selection.Rows.Count
to work out the number of rows and
For i = 0 To (noofrows - 1)

code code code

next i

to add rows is easy. just tell me what you want i the rows. hope this helps, if not email me

Thanks, but I don't quite follow so I will email you my file.