ExcelBanter - Transfer data from an excel tab to a pivot table automatically

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Transfer data from an excel tab to a pivot table automatically (https://www.excelbanter.com/excel-discussion-misc-queries/248888-transfer-data-excel-tab-pivot-table-automatically.html)

GKelly

Transfer data from an excel tab to a pivot table automatically

Hi, I have data the generates into excel sheet from a CRM platform. I want
the data that gets exported onto this excel tab to automatically generate
into a pivot table on another tab on the excel sheet. Is this possible? How
do I do this? Thanks.

All times are GMT +1. The time now is 04:38 AM.