Error Generation during copypaste macro run

Hi Guys

Plz Help me out with this situation I’m working on a project in which I had to copy data from child woekbooks (*.xls) and paste it to the master workbook with same page to page every time when a macro is executed i had done the copy and paste part

But I'm Facing the problem in which i had to deal with

Validations as on both master and child sheet validation (column based combo box is activated )
one is worktype
2ns is time type

i jst had to copy data to the master macro works perfectly fine but the problem is that a msg box appears which signifies that i had to change the name (version ) for both types when i click yes 2 times it pastes the data

I'm attaching my macro as well as pic of that msg box with this attachment

Please Login or Register  to view this content.

Cud u plz help me with this Problem
Ur Help Would be Gr8ly appreciated

I'm Attaching The Screen shot of that Msgbox
And both Dummy copies of Master And child file


i know i can use

Please Login or Register  to view this content.

to remove that but i do need more sound solution
Plz Just Help Me With any property of Paste Special WHich copies the data without this typeof validation check

and copies the data n move to next sheet

Using "Application.DisplayAlerts = False" at the beginning would be the way to go, it's as robust as anything, you may want to do a couple of other things:

Please Login or Register  to view this content.

use these at the beginning and again at the end but change them all to true!

P.S i haven't had time to look at your attachment or check the code properly

ravinder_tigh, please change the QUOTE tags in your post to CODE tags.

Thanka alot Simon Lloyd its been a gr8 help but i do need more specific solution the thing u mentioned i had applied it earlier
and thanks SHG I'll remember to post correctly cud u help me with da solutions

Try this:

Please Login or Register  to view this content.

It incorporates Simon's suggestion.

thanks shg it works wonders

You're welcome. Would you please mark the thread as Solved?