delete entire row if this AND if this...?

[Armitage2k]

Hello!

I would need to ask the local excel gods again for some help please
I have a list with arrivals from VIPs, their arrival date in column C and their name in column I. Now, I would like to clear out all double bookings (two bookings under the same name) but on the same arrival date only! If there are 2 bookings under the same name, then I would need one entry (row) deleted.
So basically the macro needs to find all entries with the same arrival date and then check if it has any double bookings, means 2 entries with 100% exactly the same name, and if yes, delete one of them. Afterwards, move on to the next day.

FYI, the list is not sorted by the arrival date if that matters.

Thanks in advance for all your help!
A2k

[JBeaucaire]

This little macro should take care of it for you. It uses two empty columns AA and AB to make a deletion key and delete the dupes all at once. This should be FAR faster than "looping" through all the rows one at a time.

If AA and AB aren't empty, just adjust the macro out to two columns that are empty.

Please Login or Register  to view this content.

[Armitage2k]

Hi!

thanks for the help. unfortunately it gets stuck at the indicated line:

Please Login or Register  to view this content.

excels screams error 1004 (object error). Well, the cells actually are empty, just in case i changed them and redid the whole thing, without success though. hmmm, any plan?

thanks a lot though!
A2k

[JBeaucaire]

You can see the -1 is missing in the third bracket. Fix that. [-1]

Sorry about that, somehow lost a digit during the copy to the forum.

[Armitage2k]

yep,works. fixed the "1" as well as the first bracket (was { instead of [). Works well now, thanks a lot!

A2k