Linking Worksheets

**Pelican** · 10-21-2010, 12:38 AM

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?

**TMShucks** · 10-21-2010, 02:30 AM

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** · 12-09-2010, 06:02 AM

Originally Posted by TMShucks

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