View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Flying_Dutcman Flying_Dutcman is offline
external usenet poster
 
Posts: 3
Default Replacing value in cell with answer of same cell

I need to replace the value in A1 with the entered value in B1. eg, A1=20;
B1=20 now I type 30 into B1 and A1=50. Is this at all posibble? Please help?