View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Copying a formula with an increase of more than 1

In any startcell in Sheet2,
say in A6 (that's where you want to start):
=IF(MOD(ROWS($1:1)-1,4)=0,OFFSET(Sheet1!$B$55,INT((ROWS($1:1)-1)/4),),"")
Copy down as far as required

Easily adapt the expression to suit for other similar situations:
a. Sheet1!$B$55 is the OFFSET's anchor, ie the startcell of the source data
b. The "4" within the MOD and INT bits is the 4 rows interval that you want
The expression avoids using the row sensitive ROW() via using ROWS($1:1)
instead to always start it at 1, irrespective of the startcell that it could
be placed in.
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Wombat" wrote:
The first sheet from which the information should be taken is called "base"
and the data goes from B55 to B138 (again, with one data value (format: text)
per row)

The linked cells should start on the second sheet in A6 and the next data
value should be in A10, A14, ...