Each week I get a report in columns with varying Nos. of rows of info.I would
like to create a macro to automaically create and format a Pivot Table in the
manner in which I would like to see this info. Is this possibleto create a
macro to do this as I seem to come up with errors when I run a macro on a new
report.

Thanking You.