How can you do this?

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
Mike
In a cell on Sheet2 enter.....

=MAX(Sheet1!D5:D12)

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loop to copy paste 5
How to Populate Data from a table to another 0
Transfering data from sheet1 to sheet2 1
Assembling Data of Many Sheets in one Summary Sheet 3
Sheet to sheet code Type Mismatch 6
Copy/Paste Template to New Workbook 11
Excel VBA to move cells to sheet2 based on selection in sheet1 0
fill in data that is not empty 1

Back
Top