View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Barry Barry is offline
external usenet poster
 
Posts: 11
Default Change the data in one cell based on content of another.

I've had a memory lapse here. I need to change the value of one cell (user
input cell) based on the content of another cell. See the following:

Materials
# Item Unit Price Qty. Total

1 $0.00 0.00 $0.00
2 $0.00 0.00 $0.00
3 $0.00 0.00 $0.00
4 $0.00 0.00 $0.00

If no item is selected unit price will be $0.00 need Qty to revert to 0.00
as well.

Thanks in advance

Barry