No, but yes. So for example:
A B C
1 =(564*12) =216 =((564*12)-216)
2 =(200*4) =45 =((200*4)-45)
3 =(568*48) =58 =((568*48)-58)

I have hundreds of row of the above (not the same numbers - all different).
Do you know how to write a macro to do this?
Thanks!


"Mike" wrote:

This is what you want in every cell in column C ???
((562*12)-100).

"kgallo" wrote:

But I don't want the cell address in column C. I want the actual formulas in
column A and column B. I just want to concatenate them.
ie: not a2-b2, but instead ((562*12)-100).
Do you know how to do that?
thanks.

"JLGWhiz" wrote:

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.