I have created a macro to copy data from a worksheet; create a new worksheet
and paste the data. However, the new worksheet has conditional formatting;
when I run the macro it deletes the worksheet along with the conditional
formatting. Is there a way to append the new data and maintain the
conditional formatting in the new worksheet so I dont have to re-enter the
conditional formatting? Thanks in advance for any help.