View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_27_] Michael[_27_] is offline
external usenet poster
 
Posts: 41
Default How can you do this?

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