comparism over 2 sheets and cross deleting

[Armitage2k]

Hello!

I need to compare data from 2 different sheets and in case of double entries,need to delete the entries on one specific sheet only.

I am comparing columns C on the VIPreport and PCPreport sheet, and in case there are any double entries, I would need to delete the specific entries on the PCPreport only. Anybody can help me out on this? My biggest obstacle is to compare from 2 different sheets, and the data of both sheets is totally different, only sometimes there happens to be a double entry.

Thanks a lot!
A2k

[Armitage2k]

OK, read myself a little more thoroughly into this materia and came up with a solution myself which fully satisfies my needs.

Instead of somehow importing the key column into one of the sheets and then start comparing on one sheet, I found a solution to step through each individual key column of each sheet and then check the correlating column on the sheet if a cell with such value exists, and if yes, delete it.

Please Login or Register  to view this content.

Actually a quite simple process, i just happen to see it way too difficult in my head ^^
Hope this approach helps someone else as well,

A2k