View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Helen B[_2_] Helen B[_2_] is offline
external usenet poster
 
Posts: 3
Default Autofill link to another sheet

Hi

I am trying to copy down a sheet reference with a step value of 51, any
pointers as I cannot seem to get "edit - fill- series" to work.

My cells references a
sheet1!B5 = sheet2!E5
sheet1!B6 = sheet2!E56
sheet1!B7 = sheet2!E107

Many thanks

Hel