How would you provide a Dynamic range in “Data Source” of Pivot Tables?

 

Report
Question
11 views

Please explain why do you think this question should be reported?

Report Cancel

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.
 

Please follow and like us:

About the Author