copy the formula

[yjmmay34]

Hello, all. I am struggling with a problem. when i write a mcro to copy some necessary data, i hope i could copy the formula of the cell. For example, i want to copy the numbers from range(Cells(8, "AP"), Cells(500, "AP")) to range("DG8") i only know the method below:

Please Login or Register  to view this content.

but this is not what i want, even though it could still work, but there will be some cases like i suddenly found there was one number has to change in column AP, then i have to run the macro again, so i hope when i copy the data, it could store the formula in the coppied side, so when i change any number in column AP, the number in corresponding column in DG will also change automatically.
is that possible to be done? Thank you all.

[snb]

Please Login or Register  to view this content.

[yjmmay34]

Please Login or Register  to view this content.

Hi,snb. I sorry but i'm not quite understand your code....The original code of the macro is like this, that's why i wrote it in that format. If like this, how should i do?? Please help. Thank you!

Please Login or Register  to view this content.

[yjmmay34]

Hello,snb. I know how to work already. thank you!

Please Login or Register  to view this content.

[snb]

or

Please Login or Register  to view this content.