| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell Reference
My worksheet has a refence to a cell in a pivot chart. Instead of the
formula being R1C1 type it is referncing the formula within the refereced cell...eg. it is returnig someting like =GETPIVOTDATA("[Measures].[Sys Qty]",$A$15,"[Period Day]","[Period Day].[Q206].[JUL].[FW200622]") instead of me simply wanting =j50. How do I do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Flexible Cell Reference | Excel Discussion (Misc queries) | |||
| reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
| Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
Threaded Mode
