| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
indirect reference to a formula?
can i enter a formula on on 1 worksheet, and then refference it on the 2nd,
as indirect(), with the intentions of having it actually calculate the refferencing worksheet? ex: sheet1, A9 contains: = sum(A1:A8) sheet2, F30 contains: =indirect('sheet1'!A9) 'with the intention of the sum of cells A1:A8 ON SHEET2 being displayed in sheet2, F30 thanks in advance, mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
indirect reference to a formula?
All you need is:
=Sheet1!A9 -- Gary's Student "mark kubicki" wrote: can i enter a formula on on 1 worksheet, and then refference it on the 2nd, as indirect(), with the intentions of having it actually calculate the refferencing worksheet? ex: sheet1, A9 contains: = sum(A1:A8) sheet2, F30 contains: =indirect('sheet1'!A9) 'with the intention of the sum of cells A1:A8 ON SHEET2 being displayed in sheet2, F30 thanks in advance, mark |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
indirect reference to a formula?
i need to use the indirect refernce because of a row insertion thing that
happens... "Gary''s Student" wrote in message ... All you need is: =Sheet1!A9 -- Gary's Student "mark kubicki" wrote: can i enter a formula on on 1 worksheet, and then refference it on the 2nd, as indirect(), with the intentions of having it actually calculate the refferencing worksheet? ex: sheet1, A9 contains: = sum(A1:A8) sheet2, F30 contains: =indirect('sheet1'!A9) 'with the intention of the sum of cells A1:A8 ON SHEET2 being displayed in sheet2, F30 thanks in advance, mark |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
indirect reference to a formula?
No, you can't use indirect in that way to change which sheet the formula
=sum(A1:A8) refers to. I think the closest you could come is in A9 of sheet1 =sum(indirect(Sheet2!B1 & "!A1:A8")) where B1 on sheet2 contains the word Sheet2 -- Regards, Tom Ogilvy "mark kubicki" wrote: i need to use the indirect refernce because of a row insertion thing that happens... "Gary''s Student" wrote in message ... All you need is: =Sheet1!A9 -- Gary's Student "mark kubicki" wrote: can i enter a formula on on 1 worksheet, and then refference it on the 2nd, as indirect(), with the intentions of having it actually calculate the refferencing worksheet? ex: sheet1, A9 contains: = sum(A1:A8) sheet2, F30 contains: =indirect('sheet1'!A9) 'with the intention of the sum of cells A1:A8 ON SHEET2 being displayed in sheet2, F30 thanks in advance, mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula + Indirect Reference | Excel Worksheet Functions | |||
| "indirect" formula reference | Excel Discussion (Misc queries) | |||
| Indirect reference | Excel Worksheet Functions | |||
| Can INDIRECT function reference a cell that contains a formula | Excel Worksheet Functions | |||
| Help with an Indirect formula to reference sheet names | Excel Programming | |||
Hybrid Mode
