Skipping Cells
 

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

Skipping Cells
 

=Sheet!A1
or have I missed something?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"CellSkipper" wrote in message
...
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

Skipping Cells
 

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.

"Bernard Liengme" wrote:

=Sheet!A1
or have I missed something?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"CellSkipper" wrote in message
...
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

Skipping Cells
 

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---

--
RyGuy


"CellSkipper" wrote:

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.

"Bernard Liengme" wrote:

=Sheet!A1
or have I missed something?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"CellSkipper" wrote in message
...
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

Skipping Cells
 

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

On Fri, 25 Jan 2008 13:03:02 -0800, CellSkipper
wrote:

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.

"Bernard Liengme" wrote:

=Sheet!A1
or have I missed something?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"CellSkipper" wrote in message
...
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

Skipping Cells
 

Whoops!

Don't need the =Sheet1!A1 in A1

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


Gord

On Fri, 25 Jan 2008 13:35:19 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

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

On Fri, 25 Jan 2008 13:03:02 -0800, CellSkipper
wrote:

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.

"Bernard Liengme" wrote:

=Sheet!A1
or have I missed something?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"CellSkipper" wrote in message
...
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