Fill

  • Thread starter Thread starter DAP
  • Start date Start date
D

DAP

I am trying to fill in cells in one sheet with every 6th cell from another
sheet. I cannot get the fill feature to increment every 6th cell on the
reference sheet. Help! When I drag the handle it increments by one. When I
click on the fill button and type in 6 then OK... it still increments by 1.
Help!
 
In Sheet1,
you can place this in any starting cell, say in B2:
=OFFSET(Sheet2!$A$1,ROWS($1:1)*6-6,)
Then just copy B2 down as far as required

This returns in B2 down:
=Sheet2!A1
=Sheet2!A7
=Sheet2!A13
and so on

Adapt accordingly to suit:
Sheet2!$A$1 : the anchor, ie the starting source cell in Sheet2
ROWS($1:1)*6-6 : the step "6"
[Do not change the core incrementer term: ROWS($1:1)]
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
 
Back
Top