| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to return a range of cells from a PivotTable
Excel2003 will not allow me to refer to another worksheet if I want to create
a Data Validation Settings: List. I would like some help on how to return a range of data from a PivotTable. I am familiar with the getpivotdata() function; is there a neat way of collecting a range. My thoughts are to create an array in a cell that might be used in the Data Validation Settings: Source. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function like INDIRECT to return a range? | Excel Worksheet Functions | |||
| I would like a function to return a value that fits its range | Excel Worksheet Functions | |||
| return range of data from lookup function | Excel Worksheet Functions | |||
| Pivottable - dynamically changing the range of cells | Excel Discussion (Misc queries) | |||
| Function to return the latest non-zero value in a range of cells . | Excel Worksheet Functions | |||
Threaded Mode
