Formula to be copied as per destination cell

Dear All,

I would like to know whether it is possible to populate the formula as per destination cell. Link which could demonstrate my problem clearly

http://software.moftalk.com/formula-...-mWtjSlgr.html

One way that I use frequently is to de-activate the top row formulae, ie edit/replace = with .=
This converts all of it into text
Then copy the text and paste it into the destination file/sheet in the exact positions
Then re-activate the text into formulae (reverse the process) via edit/replace .= with =

Thanks for your reply!!!

I didnt get the sentence "Then copy the text and paste it into the destination file/sheet in the exact positions"

if you dont mind, Can you please elaborate this.

"Then copy the text and paste it into the destination file/sheet in the exact positions"
means after you deactivate the formulas, say in A2:C2, the formulae will become text in A2:C2
Then you copy this range A2:C2 and paste it into the destination file/sheet in the exact positions