copy where ??
To make life easier, could you please upload a sample files WITH sample data, macro, formula , conditional formatting etc on some shared site like http://www.speedyshare.com/
, http://docs.google.com, http://wikisend.com/
post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
your data need not be to be real data but a good representative of how data looks like