How to remove a duplicat appointment time

[ukphoenix]

Hi Guys and Girls

You have been a great help so far but am looking to tweek now.

Currently all the macros incorporated in the workbook are working fine and doing what they need to do. What I need added is a macro that deletes rows based on a time leaving only 1 at that time.
Attached is a sample and as you can see in column A there are 2 loads at some hours. The macro needs to recognise this based on appointment time (column A) and lowest number in Column F.

If results are the same ie rows 15 & 16 then it needs to delete either row leaving 1 for 09:00

Any help is appreciated

Due to company privacy i am unable to install XL2BB so can only supply screen shots, sorry

 

[Joe4]

You actually do not need VBA to do this. Excel has built-in "Remove Duplicates" functionality (found under "Data Tools" on the "Data" menu).
Just sort your data so that the record you want to keep always come first, then you can remove duplicates rows telling Excel exactly which columns you want to use for the duplicate determination.

If you really want this as part of your VBA code, you can turn on the Macro Recorder and record yourself performing these steps manually.
That should give you most of the code that you need. If you need any help cleaning up that code after recording, post it here and let us know what you need.

 

[ukphoenix]

You actually do not need VBA to do this. Excel has built-in "Remove Duplicates" functionality (found under "Data Tools" on the "Data" menu).
Just sort your data so that the record you want to keep always come first, then you can remove duplicates rows telling Excel exactly which columns you want to use for the duplicate determination.

If you really want this as part of your VBA code, you can turn on the Macro Recorder and record yourself performing these steps manually.
That should give you most of the code that you need. If you need any help cleaning up that code after recording, post it here and let us know what you need.

Thanks for the info, didnt even realise that function was there. Have created a macro off it and works a treat

 

[Joe4]

You are welcome.
Yeah, it is fairly new functionality (not on the real old version of Excel), and a pretty cool tool!