overwrite data already present

I have a macros that copies the days attendance data from 1 sheet and pastes the dump into another worksheet.
I want to add a code that checks if todays data has already been psted or not.
In other words,

today's date is stored in a variable,
the macros looks for that date in the dump,
on finding it,
it displays a msg asking if you want to overwrite (y/n),
on receving "yes" as an answer it should overwrite todays data starting from the first cell that contains today's date else leave it as it is.

Hello there,

on receving "yes" as an answer it should overwrite todays data starting from the first cell that contains today's date

Over right it with what?

With todays attendance data already copied in the office clipboard

the macros looks for that date in the dump,
on finding it,

Where is this date located? Column and Row?

Thanks!

the date has to be searched in column B only. On locating todays date in a cell, it should ask if the data has to be overwritten, it should then paste the already copied data of the days attendence starting from the first cell that has todays date.

The main reason I am going through all this trouble is to ensure no body paste the same data by mistake. If someone wants to replace the data the macros should overwite the data already present rather than paste the data once again in new cells.

I have mentioned the code I have used to paste the data in the "RT attendance dump" file

any help???

Could you please provide an example file?

Thanks!

Please find attached an example file which contains the attendance data for the month of July.
Any help will be mush appreciated

Any help guys?????