Welcome to Excel campus my name is John and in this video I'm going to explain how to automatically update your pivot tables when the source data changes so here we have a simple pivot table and on this data sheet over here we have the source data for the pivot table and anytime we make a change to this source data range whether we edit a cell or copy and paste new data below the table we want our pivot table to automatically update so in order to do this we're going to use a simple macro and I'll explain how that works the first thing you'll want to do is save your workbook as a macro enabled workbook you can see I have this workbook here as a dot s xlsm extension if you're not familiar with that I have a whole nother video series that explains how to get started with macros in VBA and create macro enabled workbooks and I'll put a link to that in the description below this video so we're going to open the VBA editor Developer tab visual basic button keyboard shortcut is alt f11 and within the VBA editor here on the left side and the project Explorer window you want to find the workbook that you're working in that contains the pivot tables and then within that we want to find the sheet object that contains the source data so here within the Microsoft Excel objects folder this might be collapsed you can go ahead and expand it and then here is our sheet the data sheet contains that source data so we're going to double click double left-click on that and that's going to open the code module for that sheet object and then here within the code modules...
Award-winning PDF software
Video instructions and help with filling out and completing Fill Form 8815 Reload

Instructions and Help about Fill Form 8815 Reload
If you believe that this page should be taken down, please follow our DMCA take down process here.