Linking Worksheets

[Pelican]

I am using Excel 2007. I have two worksheets within one workbook. I have a list of data which totals every 100 rows. I am trying to automatically transfer those totals to the 2nd worksheet. Is there a way to do this?

[TMS]

It's possible but it's difficult to guess at the best way to do it withoiut seeing a sample of the data.

Please post a workbook with some typical data and formulae.

Regards

[meer]

It's possible but it's difficult to guess at the best way to do it withoiut seeing a sample of the data.

Please post a workbook with some typical data and formulae.

Regards

one way i am using mostly for having data from one sheet to another is the following easy way maybe you try it also if it helps
sheet1 column A1 Test
sheet2 column A1 =Sheet1!A1

[TMS]

On sheet2, in cell A1, put:

=INDEX(Sheet1!$A$1:$A$1000,((ROW()-ROW($A$1))*100)+1)

and drag down. Adjust the range as necessary.

Regards