VBA code - Copy and paste with conditional formating

[Evie76]

I have a spreadsheet that i pull data through using vlookup. Once it is in sheet 2, conditional formatting is used to detect the cells that are duplicates. I then need to be able to copy the data into sheet 3 with the conditional formatting in place, this is from C3:BE4. Can anyone help with a vba code to do this by a click of a button.

 

[6StringJazzer]

A copy/paste operation will include conditional formatting (it includes all formatting) so you just need something like this:

Public Sub CopyStuff()
   Worksheets("Sheet2").Range("C3:BE4").Copy Worksheets("Sheet3").Range("C3:BE4")
End Sub

Paste into a standard module (like Module1) and assign to a button. Modify highlighted range to suit.