How can you do this?

[Michael]

Hi everyone,

Say you have 2 worksheet in a workbook: Sheet1, Sheet2

In Sheet2, you can read d12 value from Sheet1 using "=Sheet1!d12"

Now, say I have a range in Sheet1, how can I do thing such as (from Sheet2):

"=Sheet1!Max(d5:d12)" for example?

Reagrds,
Mike

 

[Don Guillett]

"=Sheet1!Max(d5:d12)" for example
=max(Sheet1!d5:d12)

 

[Gord Dibben]

Mike
In a cell on Sheet2 enter.....

=MAX(Sheet1!D512)

Gord Dibben Excel MVP