Converting a formula to its value
I am writing a program that updates a large excel workbook on a weekly
basis. There are a couple of worksheets that I copy in the current
weeks data and the remaining worksheets perform their calculations
based on the current data. Is there a way to convert the cells
containing formulas to their values, so that next week when I run the
program the previous weeks data will remain?
Thanks in advance.
|