ExcelBanter - How do pivot table source fields automatically create tabs

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do pivot table source fields automatically create tabs (https://www.excelbanter.com/excel-worksheet-functions/85130-how-do-pivot-table-source-fields-automatically-create-tabs.html)

Datamonkey

How do pivot table source fields automatically create tabs

I'm trying to design a monthly worksheet where the pivot table source fields
always stay the same but the data is updated. I would like related/selected
source fields to automatically create tabs in the worksheet when running the
monthly updates.

All times are GMT +1. The time now is 02:15 AM.