View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davemorrison
 
Posts: n/a
Default ENTER DATA INTO 2 CELLS AT THE SAME TIME

Maybe just reference it
in sheet 1A1 you will enter the value

In Sheet2B4 enter this
=Sheet1!A1

Nopw sheet2B4 will always change when you change SHeet1A1