Thread: Reset figure in a cell to 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
  
Posts: 972
Default Reset figure in a cell to 1
Is there a way to reset a figure in a cell back to "1" when I change a figure
in another cell.
i.e.
Cell "A1" = 57315
Cell "A2" = 8
When I change "A1" to 57316, then cell "A2" changes automaticly to 1.
--
Bob
Reply With QuoteReply With Quote