Formula
 

Assuming, as in your example, each record is 9 rows high:

A1: =OFFSET(Sheet1!$A$1, (ROW(A1) - ROW($A$1)) * 9, 0)

Fill the formula down.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"John" wrote in message
...
My real question is how do I copy from the top cell so that it skips every
10 or 11 from the previous cell

Summary Sheet
a1- copy this cell
I get a2, but I want a10 in this cell

Is this possible, please help, I am despearate

----- John wrote: -----

In excel I have a excel sheet and I want to create another summary
sheet but the name in the data sheet is after every 10 rows, but on the
summary sheet, how I do this.

Data Sheet
John a1
Bill a10

Summary Sheet
a1
a10

Formula
 

Then try:
A1: =OFFSET(Sheet1!$A$10, (ROW(A1) - ROW($A$1)) * 11, 0)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"John" wrote in message
...
In the summary sheet I want to make a formula that picks steven name in
detail sheet
stevens name is in the detail sheet at a10
then joe name is in the detail sheet at a21
In summary sheet I want Stevens name in row 1 column 1=a1
then in a2 I want Joe name from the detail sheet.

Any help would be greatly appreciated

----- Rob van Gelder wrote: -----

Assuming, as in your example, each record is 9 rows high:

A1: =OFFSET(Sheet1!$A$1, (ROW(A1) - ROW($A$1)) * 9, 0)

Fill the formula down.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"John" wrote in message
...
My real question is how do I copy from the top cell so that it
skips every
10 or 11 from the previous cell
Summary Sheet
a1- copy this cell
I get a2, but I want a10 in this cell
Is this possible, please help, I am despearate
----- John wrote: -----
In excel I have a excel sheet and I want to create another
summary
sheet but the name in the data sheet is after every 10 rows, but on
the
summary sheet, how I do this.
Data Sheet
John a1
Bill a10
Summary Sheet
a1
a10