Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |