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



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

1 Answer(s)


1

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.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password