Insert row without losing function?

[houston1]

I'll try to explain this clearly. My Sheet 1 is a large data base file that needed to be consolidated to display every 5th row. So on Sheet 2 I created the formula below to do that. The problem I have now is, the data on Sheet 2 starts at A1-I1. I need to Insert 17 rows for a header. When I do that, the data for those rows are deleted because they are communicating with sheet 1. Hopefully the formula will help with explaining my problem better than I can.

=OFFSET(Sheet1!$A$17:$I$17,ROW(A1:I1)*5-1,0)
I have tried to change it to this ,ROW(A17:I17) A17:I17 being where i need it to start on sheet2. Hopefully someone can understand what I am saying and assist me with this issue.

THANKS A LOT,

jeff

[se1429]

Hi,

Try inserting this in row 18 (after the headings) and then autofill:

Please Login or Register  to view this content.

I hope it will work.