I just wanted to say thank you Roger, pulling the information into a
consolidated sheet and then creating the Pivot table, your post saved me a
few hours of VBE time. Thank you so much.

"Roger Govier" wrote:

Hi Mina

I can't find my original post in answer to Laura.
If you want to mail me direct with a copy of your workbook, and what you are
trying to achieve, I will try and sort it out for you.
To mail direct
roger at technology4u dot co dot uk
Do the obvious with at and dot to make valid email address.

--
Regards
Roger Govier

"Mina Manick" wrote in message ...
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

__________ Information from ESET Smart Security, version of virus
signature database 4530 (20091021) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4530 (20091021) __________

The message was checked by ESET Smart Security.

http://www.eset.com



.