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 <noorain.ans...@gmail.com> 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 > <robertjacob...@gmail.com>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://excelmacroworld.blogspot.com/> > *http://noorain-ansari.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
