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?

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?