Hi all, i have the code below for copying data from one workbook to another, which works reasonably well, the only problem is on the worksheet that is being copied some data is entered via dropdown boxes and some cells have comments attached, the code I am using copies everything including the comments and dropdown boxes, what do I need to change so it only copies the actual data?
2) I would like 2 columns A & B to be checked for duplicates before the data is copied, if duplicates are found then the code to stop running
hop this makes sense

scouse13


[\code]
Sub copytoworkMon()

wb = ActiveWorkbook.Name
Windows(wb).Activate
Range("A5:V550").Copy
Windows("HelpDeskWorkingSheet").Activate
Sheets("WorkingMon").Select
Range("A5:V550").PasteSpecial
Application.CutCopyMode = False

Windows("Sinbin.xls").Activate
Sheets("Monday").Select

End Sub
[/code]