| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I connect two cells? If one cell changes the other changes
The first amount i s a subtotal if that changes the cell where al the
subtotals are listed...in the overview....has to change also |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I connect two cells? If one cell changes the other changes
Example:
in H1: =A1 if A1 changes, H1 changes =Sheet1!A1 If H1 is in say Sheet2, it will change if A1 in Sheet1 changes HTH "arttrust" wrote: The first amount i s a subtotal if that changes the cell where al the subtotals are listed...in the overview....has to change also |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to connect characters together in different cells? | Excel Discussion (Misc queries) | |||
| Connect two Cells without loosing content | Excel Discussion (Misc queries) | |||
| Can I connect data from Outlook contacts to cells within Excell? | Excel Worksheet Functions | |||
| Formula to connect cells in different worksheets? | New Users to Excel | |||
| How do I connect cell color to bar chart color? | Charts and Charting in Excel | |||
Linear Mode
