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