The requirement is to update Contact custom field (Long Text Area) on the Opportunity custom field (Long Text Area) when the opporunity is created. The opportunity is created from the contact record level. 

Long text area can not be used in a formula field.

How can I disable tab refresh or page load (for a particular tab) while clicking a tab in the standard salesforce app. 
I have a search function on one of the tabs, when the page redirects to a new page, the results of the search are reset. How can I retain the search data.