Hi Nadine

Take a look here
http://www.contextures.com/xlPivot08.html
Post back to this thread if you are still having problems
--
Regards
Roger Govier

Nadine wrote:
I thought I read somewhere that you can create one pivot table from two
worksheets. Does anyone know how to do this in Excel 2003? I need to create
one and don't know how. Thanks so much.
Nadine