Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using formula to calculate data source range
Is there any way to referencing to data source range with formula?
For example I would like to insert this formula to the data surce page (if it would be possible) : =Address(32;12;1;True;"DEF_Montly")&":"&address(32 ;DEF_Monthly!$A$1;1;True) its value is: "DEF_Monthly!$L$32:$Q$32" So this way I could expand or reduce the range dinamically. Can anyone help me? Edit. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Formula to sum data from a data range | Excel Discussion (Misc queries) | |||
Formula to retrieve range of dates from a worksheet to calculate d | Excel Worksheet Functions | |||
Reference multiple cells in if statement | Excel Worksheet Functions |