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