Laura,

Did you find the resolution for the problem you stated here? If so, please post the solution. It would be a life saver for me.

Thanks,
Mina



Laur wrote:

Hi Roger.I am so glad that you posted this. You saved my life today!!
19-Jun-09

Hi Roger.

I am so glad that you posted this. You saved my life today!! I have
another problem though that maybe you can help me with. If I continually run
the macro, It includes the summary sheet

Previous Posts In This Thread:

On Monday, March 16, 2009 10:47 AM
cwar wrote:

Pivot Table from multiple sheets?
Does anybody know if I can create a Pivot Table using more than one sheet in
a workbook? I have been using Pivot Tables for a while and have never been
able to figure this out, but it would be a time

On Monday, March 16, 2009 11:08 AM
DILipande wrote:

Hi Cware,You can choose the option "Multiple Consolidation Range" when you
Hi Cware,

You can choose the option "Multiple Consolidation Range" when you create the
pivot table.

Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New

On Monday, March 16, 2009 11:15 AM
NDPar wrote:

It would be nice to know what version of Excel you are using; however, even if
It would be nice to know what version of Excel you are using; however, even
if you are using Excel 2007, you can use multiple ranges to summarize via a
pivot table, as long as they have the same field

On Monday, March 16, 2009 1:23 PM
Roger Govier wrote:

Hi CathyUsing Multiple Consolidation does not work in quite the same way as
Hi Cathy

Using Multiple Consolidation does not work in quite the same way as normal,
and may not produce the results you want.
See here for more details
http://www.contextures.com/xlPivot08.html

If

On Monday, March 16, 2009 3:32 PM
cwar wrote:

Roger, thanks for the option.
Roger, thanks for the option. I tried Multiple Consolidation twice and it
bombed my Excel 2003 application, so it was nice to have an alternative. I am
just now learning about VBE and it is value.

On Monday, March 16, 2009 4:04 PM
cwar wrote:

Pivot Table from multiple sheets?
Hi Roger:

If you get this, please disregard my last request for help to you
specifically. I figured out how to name the tabs by the year, and the source
column will fill in from there what I need. W

On Monday, March 16, 2009 5:04 PM
Roger Govier wrote:

Hi CathyThe code takes the value of the Source Sheet Name, and inserts it in a
Hi Cathy

The code takes the value of the Source Sheet Name, and inserts it in a
column just to the right of your existing data.
As I said in my earlier posting, this can then be used as one of the fi

On Friday, June 19, 2009 4:21 PM
Laur wrote:

Hi Roger.I am so glad that you posted this. You saved my life today!!
Hi Roger.

I am so glad that you posted this. You saved my life today!! I have
another problem though that maybe you can help me with. If I continually run
the macro, It includes the summary sheet

On Wednesday, October 21, 2009 2:54 PM
Mina Manick wrote:

Pivot table from two excel sheets
Roger,

I used your code in my workbook with three or four worksheets but I want to pull data only from two sheets. Please help.

Thanks,
Mina

EggHeadCafe - Software Developer Portal of Choice
Compressed Ink for Tablet PC and Windows XP
http://www.eggheadcafe.com/tutorials...or-tablet.aspx