• 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.

Macro to kill linkages to other sheet but keep the formula

E

Ecel Dumbo

Member
Hello friends,


I have a file with several sheets and these sheets are linked to one another. Within these sheets, there are addition-% calculation and subtraction formulas which do not have any sheet references.


I would like to kill the sheet linkages in each sheet but keep the addition-% calculation and subtraction formulas.


Can this be done only by Macro ? If yes kindly suggest a code


Regards,

Dumbo
 
Hi, Ecel Dumbo!


I don't fully get your point. If you change the link to the sheet, the formula result of the formula will change too, or I'm wrong?

Example: Sheet2, cell A1

=Sheet1!A1*2 (here you'll get a circular reference)

=Sheet1!B1*2 (if B1 cell differs between Sheet1 and Sheet2, the result will be different)


Please elaborate a bit more and consider uploading a sample file (including manual examples of desired output), it'd be very useful for those who read this and might be able to help you. Thank you.

Give a look at the green sticky posts at this forums main page for uploading guidelines.


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