View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Barry Barry is offline
external usenet poster
 
Posts: 1
Default how do I change the content of one cell based on another?

ITEM UNIT PRICE QTY
TOTAL



When an Item is selected It will fill in a Unit Price. User will enter
Quanity needed. Total will be calculated. If an Item is deleted, I'd like
for the Qty to revert to 0.00. Is there a simple way?