View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joey Joey is offline
external usenet poster
 
Posts: 45
Default Formula Addition Copy

Example sheet 1
a1 to a1000 each has a different number:
sheet 2
cell a1 add sheet 1 a1 to a100
cell a2 add sheet 1 a101 to 200
Is there a way to copy formula into cell a3 without editing it.