Macro to combine and sort data

[Matt2014]

Hi all,

I have data in the format of:

Material Number, Cust , Qty
DKH1222 , 1201, 1
FW11111 , 1201, 1
FW22222 , 1203, 1
FW11111 , 1202, 2


You can have the same material going to multiple customers however i want to calculate the total qty per material (regardless of customer). (E.g. two new columns on the right with part number and total quantity.

The above i imagine is quite simple for all the excel wizz's however this is the complicated bit.

I then want to then combine 3 sets of columns:

Part number Stock , Part number total customer Quantity , Part number Planned output


The catch is, some columns will contain part numbers that others do not. Therefore i want to compile a list with the following headings:


Part number , Stock , Total customer quantity , Planned output


How would i go about transforming the data from the three seperate columns into that above.

Any help would be much appreicated, thanks in advance,

Matt

[David A Coop]

Hi Matt,

Can you attach a workbook, and show some examples of what you are trying to achieve please.

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.

If this has been of assistance, please advise.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".