Pivot table using mutliple worksheets

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" <sherobot@discussions.microsoft.com> wrote in message
news:950B3854-2FBC-49BC-AB8F-F5BF14A7CA64@microsoft.com...
> 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" <sherobot@discussions.microsoft.com> wrote in message
news:950B3854-2FBC-49BC-AB8F-F5BF14A7CA64@microsoft.com...
> 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" <sherobot@discussions.microsoft.com> wrote in message
> news:950B3854-2FBC-49BC-AB8F-F5BF14A7CA64@microsoft.com...
> > Does anyone know how I would create a pivot table using multiple
> > worksheets?
>
>