Copying ranges of numbers
 

I am creating a workbook that will have many sheets. I want to be able to
add numeric data to one sheet and have that auto flow to a certain place on a
summary sheet. For instance, sheet 1 has 50 columns 20 rows. On row 20
across it totals all columns. I want those totals from row 20 to go automatic
to the summary page.Other sheets will also need to do the same. I can't get
3d reference to work right. Can't find anything else. Can anyone help me?

The basic tecnique is here

http://www.rondebruin.nl/copy1.htm

Regards,

Peo Sjoblom


"misterproperty" wrote:

I am creating a workbook that will have many sheets. I want to be able to
add numeric data to one sheet and have that auto flow to a certain place on a
summary sheet. For instance, sheet 1 has 50 columns 20 rows. On row 20
across it totals all columns. I want those totals from row 20 to go automatic
to the summary page.Other sheets will also need to do the same. I can't get
3d reference to work right. Can't find anything else. Can anyone help me?