Re: $$Excel-Macros$$ Compare multiple tables - hopefully through a pivot table?

2011-09-12 Thread Robert Jacobs 
I guess I'm in over my head.  I have no clue how to use what you just
attached.  Thanks anyway.

On Sep 8, 9:30 pm, NOORAIN ANSARI  wrote:
> Dear Robert,
>
> Please see attached add-in. It will be help to Compare Table.
>
> On Fri, Sep 9, 2011 at 12:29 AM, Robert Jacobs 
> wrote:
>
>
>
>
>
>
>
>
>
> > Thanks in advance, experts!
>
> > What I have:
>
> > 2 worksheets in same Excel file, each has a table (Table1 on WS1,
> > Table2 on WS2) with the SAME headers/type of data.
>
> > As an example (only), BOTH tables have:
> > Invoice#        Cat1Sales        Cat2Sales        Cat3Sales
> > TotalSales
>
> > The only difference is that Table1 has this info for a single
> > customer, Table2 has the info for multiple other customers.  I would
> > like to be able to bring it all into a pivot table (and have a chart)
> > that will allow me to filter and calculate % differences between
> > Table1 and Table2.
>
> > For instance:
>
> > Table1 shows that Cat1Sales make up 30% of all sales in the table
> > (Cat2Sales 50%, Cat3Sales 20%), but for other customers (Table2),
> > Cat1Sales make up 50% of all sales (Cat2Sales 10%, Cat3Sales 40%).
> > This will show the customer how their purchasing direction varies from
> > other customers', and maybe help them change their buying habits for
> > more success.
>
> > I would love to attach my existing file, but I can't seem to figure
> > that out either...
>
> > Thanks again for helping
>
> > --
>
> > --- 
> > ---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  CompareWorksheetsAdd-in.xla
> 134KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Compare multiple tables - hopefully through a pivot table?

2011-09-08 Thread Mahess Desai 
Dear Noorian,

I am quite thrilled when found the logo of your *CompareWorksheetsAdd-in.xla
*different
from the usual one. I have been trying to change logo of single file without
success.

Can you guide how can i put different logo for a couple of files in a folder
to separate them by logo? Say four files in a folder with four different
logo.

Mahess

On Fri, Sep 9, 2011 at 8:00 AM, NOORAIN ANSARI wrote:

> Dear Robert,
>
> Please see attached add-in. It will be help to Compare Table.
>
> On Fri, Sep 9, 2011 at 12:29 AM, Robert Jacobs 
> wrote:
>
>> Thanks in advance, experts!
>>
>> What I have:
>>
>> 2 worksheets in same Excel file, each has a table (Table1 on WS1,
>> Table2 on WS2) with the SAME headers/type of data.
>>
>> As an example (only), BOTH tables have:
>> Invoice#Cat1SalesCat2SalesCat3Sales
>> TotalSales
>>
>> The only difference is that Table1 has this info for a single
>> customer, Table2 has the info for multiple other customers.  I would
>> like to be able to bring it all into a pivot table (and have a chart)
>> that will allow me to filter and calculate % differences between
>> Table1 and Table2.
>>
>> For instance:
>>
>> Table1 shows that Cat1Sales make up 30% of all sales in the table
>> (Cat2Sales 50%, Cat3Sales 20%), but for other customers (Table2),
>> Cat1Sales make up 50% of all sales (Cat2Sales 10%, Cat3Sales 40%).
>> This will show the customer how their purchasing direction varies from
>> other customers', and maybe help them change their buying habits for
>> more success.
>>
>> I would love to attach my existing file, but I can't seem to figure
>> that out either...
>>
>> Thanks again for helping
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Compare multiple tables - hopefully through a pivot table?

2011-09-08 Thread Robert Jacobs 
Thanks in advance, experts!

What I have:

2 worksheets in same Excel file, each has a table (Table1 on WS1,
Table2 on WS2) with the SAME headers/type of data.

As an example (only), BOTH tables have:
Invoice#Cat1SalesCat2SalesCat3Sales
TotalSales

The only difference is that Table1 has this info for a single
customer, Table2 has the info for multiple other customers.  I would
like to be able to bring it all into a pivot table (and have a chart)
that will allow me to filter and calculate % differences between
Table1 and Table2.

For instance:

Table1 shows that Cat1Sales make up 30% of all sales in the table
(Cat2Sales 50%, Cat3Sales 20%), but for other customers (Table2),
Cat1Sales make up 50% of all sales (Cat2Sales 10%, Cat3Sales 40%).
This will show the customer how their purchasing direction varies from
other customers', and maybe help them change their buying habits for
more success.

I would love to attach my existing file, but I can't seem to figure
that out either...

Thanks again for helping

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel