Copy and Pasting Data Deletes Conditional Formatting Rules

[RayChrisJohn]

Hello,

I have a workbook with two worksheets, one with my raw data and the other for my final report. Without messing up my conditional formatting, I need to copy the data from the data worksheet to the final report. My problem is, I have some basic conditional formatting from cells B2:B49. Each time I paste the data, it removes the conditional formatting from the range that has been pasted. How can I set up the conditional formatting so that it will not be deleted with a simple copy and paste?

Thanks,
Ray

 

[MARK858]

I think you will need to copy - pastespecial-values

 

[RayChrisJohn]

Thanks! That worked.