Does anyone know how I would create a pivot table using multiple worksheets?

http://www.contextures.com/xlPivot08.html

just don't expect it to be the same as if you were using one table

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"sherobot" wrote in message
...
Does anyone know how I would create a pivot table using multiple
worksheets?

ok I think I got that part, thanks,
But what is happening is the Date column for example is ALL the same
formatting as the saleperson's name column or the item column, which is no
good.

My other question is: I'm trying to show for example a salesperson named
Gil, lets say he's has 3 different dates associated with him on sheet 1, and
I have 4 sheets.
On the master pivot table his name only appears once in my pivot table when
I should be able to see him 3 times for those different dates.

Do you know what I'm doing wrong here?

"Peo Sjoblom" wrote:

http://www.contextures.com/xlPivot08.html

just don't expect it to be the same as if you were using one table

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"sherobot" wrote in message
...
Does anyone know how I would create a pivot table using multiple
worksheets?