So I'm thinking with this ideas of creating macro code, in order to calculations and deletions some columns. My excel has many columns and headers, and the main point sometimes the information slots duplicates, in that way I have add the duplicated rows, leave only from them, and leave the value of adding them together.
Is it possible to create something like this to look for duplicated rows, adding them, deleting ? I will attach the excel.
The excel window will be "accom", and if the rows duplicate, but hotels are different I would need to add them in one slot.
The excel
docs.google.com
Is it possible to create something like this to look for duplicated rows, adding them, deleting ? I will attach the excel.
The excel window will be "accom", and if the rows duplicate, but hotels are different I would need to add them in one slot.
The excel
July_estonia_M7_diff.xlsx
Sheet EE,Invoice,DIFF Reservation Number,Tour Begin Date,Tour End Date,Hotel NetPrice,Transfer NetPrice,Extra Service NetPrice,Acc.Amount,Transfer Amount EUR,Extra Amount EUR,Acc.Amount,Transfer Amount EUR,Extra Amount EUR 558,01.07.2021,08.07.2021,1489.92,20,0,1,489.92,20.00,0.00,0.00,0.00,0.00...
