|I don't understand what you are trying to do.|
Are you trying to copy a formula or copy data?
Perhaps an example of your data, before and after, would help.
Please read the How To in the following line before posting data.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.