View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joone@hotmail.com is offline
external usenet poster
 
Posts: 6
Default Need Help with Macro

COL A: Items
A1: "Item 1"
A2: "Item 2"
A3: "Item 3"

COL B: Current Balance
B1: "100"
B2: "150"
B3: "205"

COL C: USED
C1:
C2:
C3:

I need a Macro wriiten to subtract Column C from Column B; update Column B
of the current balance and delete the number used at column C as soon as the
current balance is updated.

I hope I'm clear with my request. Thanks in advance.