Converting Specific Formulas into Values

[pareshvm]

Hi Experts,

I have excel file having multiple sheets having formulas such hlookup, sumifs,vlookup,sum, etc

I want to convert the specific formulas (such as hlookup, vlookup, sumifs) into value (not the entire sheet and all formulas)

Please advise.


Regards
Paresh

[Jakobshavn]

Try this small macro:

Please Login or Register  to view this content.