Subtract

[cmlm]

On sheet A, I have column: A1(product name) A2(quantity).

When I copy a row with the data in above columns to sheet 2, it must
automatically deduct 1(one) from A2.

Can you please help?

Thanks.

 

[Frank Kabel]

Hi
this would require VBA (using event procedures) Do you really want to
go this way. Note: excel is IMHO not well suited for maintaining an
inventory

 

[CLR]

Maybe.....
In Sheet2 cell A1, put...........=Sheet1!A1
In Sheet2 cell A2, put...........=Sheet1!A2-1
In Sheet2 cell A3, put...........=Sheet1!A3
etc etc etc

Vaya con Dios,
Chuck, CABGx3