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