View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex Martinez Alex Martinez is offline
external usenet poster
 
Posts: 18
Default cell reference using macro


Hi,

I am using Excel 2002 and I want to do a macro that will cell reference
from one worksheet to another. For example I want Sheet 1 cell B10:C17 to
be able to reference from Sheet 2 F10:G17. I don't want to do a copy and
paste, because the user may change the data in Sheet 2. Any tips or
suggestion will be appreciated. Thank you in advance.