In column C2 type

=a2 - b2

Then drag it down the entire column for as many rows as you have data in
columns A and B. To drag it down, select the cell with the formula in column
C and put the mounse pointer on the node at the lower right corner of the
selection outline until it forms a plus sign. Press and hold the left mouse
button and drag down. It will copy your formula and assign the appropriate
row numbers as it does so.

"kgallo" wrote:

I am trying to write a simple macro to an essence do the following:
A B C
1 =(564*12) =216 =((564*12)-216)
2
3

I want a macro to do column C. I have hundreds of rows where I need this and
would rather not type them all out.
Any help would be much appreciated!
Thanks.