(Solved) – Change a range to values if a criteria of another range is met?

(solved)-–-change-a-range-to-values-if-a-criteria-of-another-range-is-met?

I have a worksheet in which in the first row (starting from D1) I will have Answer “YES” and Answer “NO”
If the answer is “YES”, the macro must convert all formulas to values in a specific range.

For example:

If D1 = “YES”, then convert to values range D2:D2000

If AA1 = “YES”, then convert to values range AA2:AA2000

If AC1 = “NO”, then do nothing

Hopefully it is easy to do..

EXAMPLE

Leave a Reply

Your email address will not be published. Required fields are marked *