Excel Cell Link in Increments

[sabrinigreen]

Hello,
I am linking up two worksheets. However, the data in one of the worksheets is in every 29th row

For example, in sheet Weekly Summary, in cell A1, I am linking to data in sheet Machine, cell A29

I want to be able to reference in Weekly Summary, in cell A2, the data in sheet Machine, cell A58 and so on

So I what I have in my Weekly Summary worksheet column A is:
=Machine!A29
=Machine!A58
=Machine!A87

And I want to be able to just drag it down and have it reference every 29 cells.

Thank you!

[sabrinigreen]

Okay, I did a workaround, but I'd still like to know if there is a way to do this.
What I did was create an incremental list in a new sheet (column B)
29
58
87
on down
put the text Machine! in column A and pasted it all the way down (by double clicking the fill handle)
combined the text of column A&B in column C (using &)
copied that into a notepad document
Replaced Machine with =Machine
and pasted that into my spreadsheet

(when I put = into the excel spreadsheet it came up with a reference error, which is why I did the notepad thing)

[DBY]

Hi
Try the following formula:

=OFFSET(Machine!$A$29,(ROW()-1)*29,0,1,1)

You can drag this down from A1 on your Weekly Summary sheet.

Hope this helps