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 Copy/Fill Down in increments

I have a fomula on sheet1 that refers to sheet2 and I want to copy/fill down
adding 51 each time.

Example in Sheet1 cell B4 is =Sheet2!E5, I want the result in B5 to be 51
rows later ie =Sheet2!E56

How can I autfill or copy down to automatically add 51.

Thanks