Copying ranges of numbers

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

have cell in sheet 1 look up last row of column 'x' in sheet 2 4
Indirect function and relative references 4
3D summing a named range. 2
linking sheets in workbook 2
Create summary sheet of last row of info from other sheets 5
SUMIF?? 4
Sumproduct function multiple sheets 4
copying data to summary sheet 2

Top