Embed linked values

[plans]

Hello,

I have a worksheet (MyWS)containing numerous values reading from other worksheets, from the same or, from different workbooks through the "=" sign like:

=Sheet2!C9 or like: =[MyBook]Sheet1!$C$3.

What I am trying to achieve, is to have a macro searching through MyWS and embed / replace the formula with the value of the formula, similar to what copy / paste Value does.

Could you please advise?
Thank you

[kvsrinivasamurthy]

Try this Macro

Please Login or Register  to view this content.

[plans]

kvsrinivasamurthy,

Thanks for looking into this, however, the intent is to copy/paste only those values which are reading from an external worksheet or workbook.

The formulas which are reading values from the active sheet needed to be kept "as is", for exemple, a formula such as :
=SUM(B1:B2), needs to stay the way it is; somehow, to ignore the formulas which do not contain the "!" mark.

Could you please advise?
Thanks

[kvsrinivasamurthy]

Try this

Please Login or Register  to view this content.

[jolivanes]

@ kvsrinivasamurthy
I would change these two lines

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

and do away with this

Please Login or Register  to view this content.

[kvsrinivasamurthy]

@ jolivanes

Ok. Thank you

[plans]

Thank you!