sidpys
05-13-2012, 06:20 AM
Hello,
First of all sorry for my bad English
I need help to make macro in excel to detect if 2 row in a column have same value then sum value in each row to a new row above and delete 2 original row
For now i doing it manually, but that consume a lot of time because i have a lot of data to process
Herewith i attached some of the file, original sheet is what i get from system and i have to edit manually become target sheet
I truly appreciate any help you can give.
Regards
Sidpys
First of all sorry for my bad English
I need help to make macro in excel to detect if 2 row in a column have same value then sum value in each row to a new row above and delete 2 original row
For now i doing it manually, but that consume a lot of time because i have a lot of data to process
Herewith i attached some of the file, original sheet is what i get from system and i have to edit manually become target sheet
I truly appreciate any help you can give.
Regards
Sidpys