ExcelBanter - Pivot Table from 2 worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Table from 2 worksheets (https://www.excelbanter.com/excel-worksheet-functions/263487-pivot-table-2-worksheets.html)

nadine

Pivot Table from 2 worksheets

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

Roger Govier[_8_]

Pivot Table from 2 worksheets

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

All times are GMT +1. The time now is 12:59 AM.