Subtract

  • Thread starter Thread starter cmlm
  • Start date Start date
C

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.
 
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
 
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
 
Back
Top