Thread: how do i enter data in multiple sheets simultaneously
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EdMac
 
Posts: n/a
Default how do i enter data in multiple sheets simultaneously

Hi Usman,

Normally you would do this by referencing the subsequent sheet cell to
the one where you have entered the data, so if in sheet1 cell A1 you
input a value, then in sheet2 A1 you would enter
=sheet1!A1

HTH

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=522605

Reply With QuoteReply With Quote