combining two sets of data

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.
 
N

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
 
H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top