I prepare reports using the Pivot Table function. My goal is to automate
preparation, but errors are encountered due, I think, to the fact that the
number of records (rows) varies with each report.

Accordingly, I have to format the Pivot Table manually each time a report is
prepared.

Can anyone suggest a way to automate the Pivot Table preparation or offer an
alternative suggestion?

Thanks for your responses.

Johnny