Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic formula for Pivot Table
Hello,
Im using Excel 2000. Im trying to name a range for a dynamic formula to be used in a pivot table. I found a very good tip on this site, but I cant get the named range to work. Here is what I've done: I name the range by choosing Insert Name Define I type my name RRBB001 without the quotes. In the Refers to box I type =offset(data!$A$1,0,0,Counta(Data!$A:$A),7) I click OK Then a choose the pivot table and for the range I type RRBB001, click Next Here is where I get the error message Reference is not valid However, when I go back into Insert Name Paste, the name prints and the offset formula. Help is appreciated as always. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic range in Pivot table | Excel Discussion (Misc queries) | |||
Pivot table dynamic Filter | Excel Worksheet Functions | |||
Dynamic Range in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table - Dynamic Field | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |