Yes, I should specify that it's a monthly job as users now need to manually
retrieve data from different worksheet then copy/paste for several hundred
cells per spreadsheet. Plus those cells are spread across different rows
within many different columns, it's time consuming as they can't do the a
group copy/paste at once...That's why I tried to see if we can setup the
Vlookup formula for all months in advance. It would solve the problem except
I couldn't 'Do thing' within the IF formula for past months. With the
limitation of the IF formula, I like to know what and how to solve this
problem. Any more suggestions?

"joeu2004" wrote:

On Jul 7, 5:54 pm, paic101 wrote:
How easy a macro can be developed to remove the formula but leave the value
alone for a group of cells when a special condition matches like my example
here?

I confess I really do not understand the problem you are trying to
solve, specifically if this a one-time thing or repeated periodically,
and if this impacts only one cell or more. I found your explanation
confusing.

But I wonder if you need a macro at all. Would the following suit
your purposes?

Simply select the cell with the formula to be replace, right-click
Copy, then right-click Paste Special and select Values.