copy data

[scouse13]

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]

[Greg M]

Hi there,

The following code will copy the data values from the specified range in the active worksheet to the same range in the specified target workbook and worksheet:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[scouse13]

thanks Greg m worked a treat

[Greg M]

Hi again,

Many thanks for your very prompt feedback.

You're welcome - glad I was able to help.

Best regards,

Greg M

[MarvinP]

Hi,

It looks like in Excel 2010 and newer they have built into the VBA the ability to use all the Paste Special features. Read about it at:

https://blog.udemy.com/pastespecial-vba/