Copy and paste data from one sheet to another, check if data is dupliacte. if it is ask user if they want to continue

[seansta13]

Hi

I have a sheet I am using as a booking form. I want to copy the data from cells D4 to G4 on sheet 1 to sheet 2. when the data is copied onto sheet 2 I want to add it to the next available row and check if the name in column B is a duplicate anywhere is the table. if the data is a duplicate I would like a message box to show the user the duplicate row/rows showing them all the data i.e. Cell B thought to F on the duplicate row. I then want to ask the user if they still want to copy the duplicate data to sheet 2 having viewed the duplicate info.

thanks in advance

 

[seansta13]

Even better if it could only check if the duplicate name is within the last 6 months that would be even better