pls make macro for this....

[danushka]

Dear friends in my excel work sheet base on column "D" i want to check duplicates...if any values are repeated in column "D" then same row column "F" value should combined & that repeated rows should delete...... pls make macro for this.thanks in advance....

my normal document...

expected results.....

that column "F" combined values should come in this format..

=8+4+154

 

[danushka]

bump....

 

[Marcelo Branco]

Hi,

Questions

1. Data in Sheet1, columns B:G, headers in row 1?

2. the macro must check only column F for duplicates, no matter the voucher # or date? In other words, can you have the same code in another voucher and if so this should NOT be deleted?

M.

 

[danushka]

Hi,

Questions

1. Data in Sheet1, columns B:G, headers in row 1?

2. the macro must check only column F for duplicates, no matter the voucher # or date? In other words, can you have the same code in another voucher and if so this should NOT be deleted?

M.

headers in row 8 & data starting from row 9.don't think about other columns.pls make macro for this.....

 

[obiron]

Why can't you use a pivot table to aggregate the data?

The board is not about providing you with a solution, it is about teaching you how to find it yourself.