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?