how to get the value of sheet1 in sheet2 with the document method?

Topics: Developer Forum, User Forum
Oct 15, 2009 at 6:58 AM

i know we can use name range to set a global variable in sheet1, and use it in sheet. can we use below way to get the values like the excel code?



ms excel:



anyone can help me? many thanks!

Oct 15, 2009 at 11:44 AM

Try to set this formula in sheet2: