Sun, 20 May 2007 10:50:00 -0700 from Guido Cole
Excel 2003
Sheet 1: I have data in A1, A2, A3,A4,A5 ... A365
On Sheet 2, I need to copy the data from every 7th row on sheet 1 and would
like to do this with autofill.
Guido,
It's not clear to me whether you want to (a) put data in sheet 2 A1,
A8, A15, A22 etc. or (b) put data into sheet2 A1:A52 (every seventh
row of sheet 1 collapsed into sheet 2).
Could you clarify, please?
And if you do want (a) then what is to go in sheet 2 A2:A7, A9:A14,
A16:A21 etc.?
If you want (b), here's how. Put this in sheet2 A1:
=OFFSET(sheet1!A$1,7*(ROW()-1),0)
Then click and drag through A52. If you're setting up your array in
sheet 2 starting somewhere other than row 1, change the "-1" in the
formula to minus your starting row number before you click and drag
down 52 rows.