enter the formula as you normally would, and when you have to reference
another worksheet, simply select that worksheet, navigate to the cell, select
it, and then go back to your formula.
--
Brevity is the soul of wit.


"ChrisPrather" wrote:


Does anyone know how to reference data on multiple worksheets or all of
the worksheets in the same workbook? I know you can reference all data
in a given column by using A:A for example. How can you do the same
thing with worksheets?


--
ChrisPrather
------------------------------------------------------------------------
ChrisPrather's Profile: http://www.excelforum.com/member.php...o&userid=37743
View this thread: http://www.excelforum.com/showthread...hreadid=573836