| 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 |
| 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 | |||
Threaded Mode
