Forum Discussion

Rujinh's avatar
Rujinh
Copper Contributor
Mar 06, 2020

Excel PivotTable

I need help finding the best way to combine worksheets and creating a PivotTable from all the data. Also, every month I get a new report I download and add to this particular workbook but how can I get that newly added data to combine to my PivotTable I currently have. I've tried using the PivotTable and PivotChart Wizard but every time I want to add that new data, it gives me an error message. Please see my attachments to see what I mean. I would like to know an easy way where I can do this and continue to add data to my workbook without it messing up anything else.

BI & Data Analysis
excel

4 Replies

    • Rujinh's avatar
      Rujinh
      Copper Contributor
      Mar 06, 2020

      ChrisMendoza thank you for that video, I will take a look at it and see if I can follow along with my workbook. So, will that let me continue to add on to my workbook as it becomes a new months report?

      • ChrisMendoza's avatar
        ChrisMendoza
        Iron Contributor
        Mar 06, 2020

        Rujinh - If I recall correctly, this was the first video showing the basic idea and later another video was created on the channel that may address adding new Worksheets. It will be a great starting point for you to learn.

Resources