• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

copy formula from one sheet to another sheet

M

mckhoa

New Member
I have a series of formula that is linked on sheet1, I would like to copy those formulas to sheet2 while still linking to sheet1, is there a way to do it in mass, I have about a thousand formula so it would take forever to do it by hand.
 
Hi ,


Can you clarify whether the formulae you want to copy are in a particular range or is it an entire worksheet ?


If it is a range , then select the range , do a FIND AND REPLACE , and replace all the = signs with the text #= e.g. a formula like =IF(F13>0,G13,H13+7) will become #=IF(F13>0,G13,H13+7). This is a text string , and can be copied anywhere else without the references getting changed by Excel.


After the copy has been done , again do a FIND AND REPLACE , and replace all the #= text with the sign = , which will restore all your formulae.


Narayan
 
You must log in or register to reply here.
Back
Top