Skipping Cells

[CellSkipper]

I am using two sheets of information. In the second sheet I want to take a
cell from Sheet one and then skip down cells in sheet one to get the next
cell. Is there any way to create a formula that will do that?

Sheet
A30 235-364
A60 211-354

I want to create formula that will allow me to get these two cells without
having go back to Sheet 1 every single time

 

[Bernard Liengme]

=Sheet!A1
or have I missed something?

 

[CellSkipper]

What I want is to take Cell A1 and Cell A31 and Cells A61 from Sheet 1 to
Sheet 2 in one move. I want to take information from every 30th cell.

 

[ryguy7272]

If you are on a different sheet:
=INDEX(Sheet1!$A:$A,(ROWS(Sheet1!$1:1)-1)*30+COLUMNS(Sheet1!$A:B)-1)

If you are on the same sheet:
=INDEX($A:$A,(ROWS($1:1)-1)*30+COLUMNS($A:B)-1)

Then, fill down...


Regards,
Ryan---

 

[Gord Dibben]

In Sheet2 A1 enter =Sheet1!A1

In Sheet2 A2 enter =OFFSET(Sheet1!$A$1,30*ROW()-30,0)

Drag/copy A2 down as far as you wish.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Whoops!

Don't need the =Sheet1!A1 in A1

Enter =OFFSET(Sheet1!$A$1,30*ROW()-30,0) in A1 then copy down.


Gord