i have a template and from client a workbook will i should compare and paste the data if any new row der i should insert in template file and that inserted data should also paste 7times in the same workbook and sheet name is upload.
but main problem is inserted data is in rows and in upload we should check the date creteria and paste it whr the row inserted in template file
below is the code for comparing and inserting the row in template
Sub Copy_Paste() Application.EnableEvents = False
Dim x, y As String Dim i, j As Integer
x = Application.GetOpenFilename() Set wb = Workbooks.Open(x) y = Application.GetOpenFilename() Set ws = Workbooks.Open(y)