I run a very small online drop shipping business in my spare time, I have some transaction details created by the website in Excel format.

Each transcation line contains a code that indicates a number of line items on a bill (e.g. DPT-15 is one 15kg sack and one delivery charge, DPT-30 is two 15kg sacks and one delivery charge) I wish to "explode" the group codes into individual transaction lines.

I am having a complete mental block on how to tackle this, I am fairly handy with macro's for finding and matching data but I am not sure of an effective way of structuring my worksheets to do this.

I have attached a mock spreadsheet of the sort of thing I think I am looking for but happy to have other ideas suggested. Example transaction.xls

I have broken it down into three sheets, the first contains the parts of the groups. The second the raw data and the third the output I am looking for.

Many thanks for any suggestions,

Mike