Please help me make a basic Excel Macro!

[airborne]

I need to make an excel macro to work out the cubic meters of an object, height x breadth x length = Answer(cubic meters)
And then the new total cubic meters auto summed as each subsequent line/object is added.

That can't be too hard but I am useless with excel, could anyone perhaps help with making that macro please?
I'm using Excel 2010

 

[Cray]

I need to make an excel macro to work out the cubic meters of an object, height x breadth x length = Answer(cubic meters)
And then the new total cubic meters auto summed as each subsequent line/object is added.

That can't be too hard but I am useless with excel, could anyone perhaps help with making that macro please?
I'm using Excel 2010

No need to use Macros, formulas would do the job just fine.

One column for each particular dimension, and in the 4th column something like "=a2*b2*b3" (assuming row 2, Leave out the quotes). You can just pull this formula down to any subsequent rows... (bottom right of cell with formula, when you see the + symbol, drag down)

Then just put in an autosum near the bottom to sum all of the results in column 4

 

[rorz0r]

No need for a macro.

In a new column:
press =, click height column, press *, click breadth column, press *, click length column, press enter

Should end up with the formula saying something like "=A1*A2*A3"

Then in another cell press =, type SUM( and then click the letter at the top of the previous "answer" column, and press enter. Should say something like "=SUM(D)".

 

[Coasti]

 

[D4N_CPT]

Row 1 : Headings
Row 2 : =A2*B2*C2
Row 3 : =D2+(A3*B3*C3)

And then you simply drag down Row 3's formula, with the bottom right corner, as far down as you would like.



The brackets is just to make it easier for a human to read...

 

[gokool]

Airborne. I'm sure you had a reason you wanted a Macro. Would you care to share that with me?

 

[maumau]

Airborne. I'm sure you had a reason you wanted a Macro. Would you care to share that with me?

+1

I also need to know how to do a simple macro