Using a CELL value to search for Duplicate in a COLUMN

I have say Cell B3 this is always a date on a sheet named Party Times on another sheet I have a column of dates with entries, say it is column D this sheet is named Party Schedule.

I need to check Cell B3 (4/30/2014) with all of the Column D on sheet Party Schedule to be sure I do not schedule another party on the same date...

Also doing this it needs to be somewhate of a do --- while if there ARE NOT any dates overlapping then go ahead and copy and paste the macro to the sheet if there are msgbox "PARTY ALREADY SCHEDULED PLEASE RESCHEDULE).


ANY HELP IS GREATLY APPRECIATED

I have no idea what you are trying to say here:

Also doing this it needs to be somewhate of a do --- while if there ARE NOT any dates overlapping then go ahead and copy and paste the macro to the sheet if there are msgbox "PARTY ALREADY SCHEDULED PLEASE RESCHEDULE).

For the parts I can understand, try this:

Please Login or Register  to view this content.

This does what you want I think. Don't know where you're copying & pasting to

Please Login or Register  to view this content.