I have 4 columns in my table (tblAccounts). I am trying to find any duplicates that may exist in Col A (Name Account Number), sum values in Col D (Name Account Value), then delete the entire row. So far my sheet before.
Col A
100
101
102
105
100
101
102
105
Col D
5
4
2
4
1
2
3
1
After my code is run, I need for my spreadsheet to look like this
Col A
100
101
102
105
Col D
6
6
5
5
Do someone has any idea how I can implement it?
Thanks a lot in advance