We can **create a dynamic Pivot Table** in Excel by copying and pasting a new set of data directly below the data table. Afterward, we will **refresh** the Pivot Table to include the **new data**. This is better than the **OFFSET function** used in earlier Excel versions. The steps below will walk through the process**.**

*Figure 1- How to Create a Dynamic Pivot Table in Excel*

**Setting up the Data**

- We will use the created Pivot Table in
**figure 2**to make a Dynamic range Pivot Table

* Figure 2 – Setting up the Data*

**Creation of a Dynamic Pivot Table**

- We will
**add two more dates**and**sales amount**to the data table - We will do this by clicking
**Cell A21**and paste the data

* Figure 3- Dara added to Row 21 and Row 22*

- We will right-click on any part of the Pivot table and select
**refresh**

* Figure 4- Prompt to replace the current Pivot Table*

**We will click Yes**

* Figure 5- Created Dynamic Pivot Table*

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment