combining two sets of data

[nullisecundus]

Dear All,
This is my first query.
I have been struggling with the following , I have got a pivoted excel sheet
with the following fields for each of 2008 and 2009. ,i.e. I first pivoted
for '08 and then for '09. to get two sets of data.

|customername|grade|total qty.

now I want to make a comparison sheet which should like this

|customer name|grade|total qty. '08|total qty. '09|

As it happens in sales , some customers have added some more grades
vis-a-vis 2008, some customers have not purchased anything in '09 and some
new customers have been added.

IN this consolidated comparative sheet I need to merge the data each for 08
and 09 so that i can arrive at one sheet with all the information without
duplicacy.

trust i have been able to explain the problem, any help would be deeply
appreciated.

TIA,
Nullisecundus.

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Merge Tables.
http://www.mediafire.com/file/hzqrlgzzwyo/07_04_09.xlsm
Excel 2003?, no VBA?, good luck.

 

[nullisecundus]

Dear Herbert,
Loads of thanks for your efforts, When i run this in my sheets I get a
runtime error 9. when i try to debug this the undermentioned line is
highlighted in the VBE.

With Sheets(ss).ListObjects(sd) 'Delete old data

you will have to excuse my ignorance as i dont have any knowledge of VBA .

trust you can guide me further.

Thanks a lot again

Nullisecundus

 

[Herbert Seidenberg]

As hinted in my first post, VBA knowledge is required.
The variables ss and sd are sheet names and table names
that have to be defined for your particular application.
As a starter, play my file as a template and edit the data
one step at a time. Re-download if it crashes.