Have you tried looking at the "help" for these functions?
Do you understand functions at all?
As far as retrieving data from one sheet to another:
Let's say in sheet1, Cell A2 you want the value from Sheet2, Cell A2.
in Sheet1, you insert the "=" sign, then switch to sheet2 and select cell A2.
The result is the formula:
=Sheet2!A2
Now, say that you want to enter a cell value in A1 and have cell A2 use THIS
value to decide what cell to bring from sheet2.
Insert the string "A2" into cell A1 of sheet1.
Then, modify your formula from A2 to read:
=INDIRECT("Sheet2!" & A1)
although there are easier ways to do this, but I suppose it has it's uses.
--------------------------------------------------------
Address: converts Row/Column numbers to a R1C1 style reference.
as in: row 3, column 2 is:
=Address(3,2)
and results in $B$2
=row() returns the row number of the cell that holds the formula.
=row(B5) returns the Row number of cell B5, or 5.
Paul
>
>From: bhavya khanna <bhavya...@gmail.com>
>To: excel-macros@googlegroups.com; davebonall...@hotmail.com;
>stvptter...@live.com
>Sent: Thu, October 7, 2010 12:11:58 PM
>Subject: $$Excel-Macros$$ What is indirect Function?
>
>Hi Everyone,
>
>
>What is indirect Function and Address function and row function , column
>Function . How Can we retrieve data from sheet 2 to sheet 1 using indirect
>function . ?
>
>
>Please explain It .
>
>
>
>
>Thanks and Regards--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
