Macro to convert formuales into values based on date criteria

Hello Users,

I am looking for guidance on using a macro that will convert the formulaes to values in the desired cells based on the date range.

Eg: When this file is opened for next month (May 2013), the formulaes in cells ("G17: J17") should be converted into values and so on. As soon as the user opens this file, the macro should be able to expand the range of the values to be converted, by comparing the date in Cell "A1" with the values in row # 6. Essentially the area to be converted increases as the months pass by.

I hope I have been able to explain my issue clearly. Request VBA gurus to kindly advise me on this....

Thanks,
FS

P.S - The attached file is a dummy of the real version to be used, hence only cell A1 contains formula.

G17:J17 are already values, except for cell A1, there are no formulas on your worksheet to convert to values.

If you did have formulas in G17:J17 then all you need is,

Please Login or Register  to view this content.