Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining two sets of data
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining two sets of data
Excel 2007 PivotTable
Merge Tables. http://www.mediafire.com/file/hzqrlgzzwyo/07_04_09.xlsm Excel 2003?, no VBA?, good luck. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining two sets of data
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" wrote: Excel 2007 PivotTable Merge Tables. http://www.mediafire.com/file/hzqrlgzzwyo/07_04_09.xlsm Excel 2003?, no VBA?, good luck. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining two sets of data
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
3 Different Data Sets | Charts and Charting in Excel | |||
Combining information in sets of columns | Excel Discussion (Misc queries) | |||
help comparing two sets od data to find the odd data | Excel Worksheet Functions |