Simple Excel Macro

Dear All I have an excel spreadsheet which has various column with quantity and name of the piece. Actually there is a small macro that create a txt files, but I'm looking that someone integrate this macro to try to develop something like this: From this columns: 1 | MI AN 32 | 2 | MI AN 90 | 7 | AN 32 1 | MI AN 56 | 3 | AN 32 | 1 | MI AN 32 To a txt file with a sum like this (in addition to the existing output): 2 MI AN 32 2 MI AN 90 7 AN 32 2 MI AN 32 1 MI AN 56 If you open the attached files, you can see 2 sheets. One is the dashboard with the button and the macro, and the second one is the sheet with the data (from coloumns AC to AT, the first one is for quantity and the second one is for the code...max pieces are 9) Please bid only who are experts and has the ability to run macros etc. ....... this been a simple project for an expert. Thanks