=MAX(B12,B40,B65)
=MAX(Sheet1!B12,Sheet2!B40,Sheet3!B65)

Vaya con Dios,
Chuck, CABGx3


"telewats" wrote:


This is good to know. Thanks for the info.

What if I want to use cells that aren't in conjunction with one
another, ie. B12 & B40 & B65? Or if I want to pull data from multiple
spreadsheets?


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=499387