Hi Jeff,

Thank you for your advice. I was able to consolidate data from two worksheets into one pivot table following your help and direction although I have been unable to manipulate the columns into the format I want for printing but that is something I will work on.

The other frustrating thing, although I am sure there is a very simple answer I have failed to find, is that every time I 'Refresh' to load new data into the pivot table the columns automatically adjust reducing the width to accommodate the largest set of data. I want it left at the widths I set ready for printing.

Any clues!?

Thank is again for your help.

Regards,

Don