combining two sets of data

  • Thread starter Thread starter nullisecundus
  • Start date Start date
N

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.
 
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
 
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.
 
Back
Top