Copy and paste sheets with conditional formatting

[Jack-P-Winner]

I have a book with 10 identical sheets (or they should be but are not) anyway. If I delete 9 of them knowing 1 is correct Can I copy and paste new sheets with the CF attached or will I gave to reprogram each sheet over again?

Thanks
Just trying to brain storm some errors

 

[bobhc]

Just click on the sheet tab and choose copy, then follow the steps to achieve as many sheets as you need

 

[Jack-P-Winner]

I understand that part BUT will my CF copy and paste correctly? The SAME as the original I'm copying from?

 

[vijay.vizzu]

Dear Jack.. it will copy everything u have in that sheet, including your CF and formulas etc...

 

[bobhc]

......BUT...

I understand that part BUT will my CF copy and paste correctly

so I take it from your further question and the prompt from Vijay you have not tried as I suggested, you can try anything to excel it a test workbook..... Have you done this?....Have you tried!!!


.

 

[Jack-P-Winner]

Sorry bob, its called having an infant in the house and I just tried it. It did copy and paste everything exactly except it messed up my reset macro some how. Not sure how yet

 

[bobhc]

Don't be too hard on yourself..... I would not refer to you as an infant....


.