I am not sure if it makes sense or not, do you want to increment with 13 per
row you copy down so you will get what's in Sheet1 B4, B17, B30, B43, B56 and
so on? If so this formula will do that

=OFFSET(Sheet1!$B$4,ROW(1:1)*13-13,)

Regards

Peo Sjoblom

"Big G" wrote:

I want to create a secondary excel sheet that combines information from a
primary sheet. The primary sheet contains an extract of data from Pastel
which is an asortment of data in rows and columns. However, the data is
repeated at regular intervals. Eg. Cell B4, B17, B30 contain same data for
different clients. I want a formula that I can drag and drop which increases
the cell reference from =sheet1!B4 to =sheet1!B17, to =sheet1!B30 etc. Sheet
2 will have all data in columns, the first row of which I have copied across
to sheet 2 as =B4; =B5; =A7;=D4; etc.
Hope this makes sense.
HELP
--
GJC