| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I Link two worksheets?
I would like excel to search for all references to ex. "TV/VCR" that is being
used in a particular room ex. "PA" and keep a running total that is linked to a cell on another worksheet labeled 'PA'. Does anyone have any ideas how this can be done? |
|
#2
|
|||
|
|||
|
Hi
not sure exactly what you're after but check out COUNTIF in help and see if that is useful - or the SUMPRODUCT function at http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Compton Hubbard" wrote in message ... I would like excel to search for all references to ex. "TV/VCR" that is being used in a particular room ex. "PA" and keep a running total that is linked to a cell on another worksheet labeled 'PA'. Does anyone have any ideas how this can be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link Worksheets | Excel Worksheet Functions | |||
| how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions | |||
| Put same data in cells on two different worksheets (link?) | Setting up and Configuration of Excel | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| What formula do I use to link worksheets together within one spre. | Excel Worksheet Functions | |||
Linear Mode
