Me again!!

I'd like help in creating both a pivot table and chart with VBA code please.

I have data in a sheet called "Data Entry" from column A to N, with headers in Row 4. The data is dynamic and will grow to well beyond 1000 rows

I can easily create a permanent sheet for the PT and Chart, but this makes the file quite large.

I'd like the code to create a sheet for the pivot table and one for the pivot chart, so that when we're finished our diagnostics, we can delete these sheets and on opening the file again, we could click a button to recreate them again

As usual, any help would be greatly appreciated

Regards,

Kawa13