| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
update consolidated sheet when data is added to worksheets
As I add numberic information to a number of worksheets I want the
consolidation sheet to be updated with the new total. I find that when I have information going to the consolidation sheet then enter a new value in the worksheet that the total of the column is not reflected in the consolidation sheet. The consolidation sheet still shows the total that was and is in the cell that was used for totalling in the first calculation. Can I make the value shown in the consolidation sheet a "floating" cell from the worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
| How do I pull certain data from several worksheets in one sheet? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
