How would you provide a Dynamic range in “Data Source” of Pivot Tables?
1 Answer(s)
send4favas
To provide a dynamic range in “Data Source” of Pivot tables, first create a named range using offset function and base the pivot table using a named range created in the first step.
Apr 24 2014 08:03 PM