I have created a file with many formulas that create other formulas when evaluated. This is done to facilitate copying formulas.
Now I need to evaluate each of the formulas so that they will become the formulas they are intended to be. To do so, I must press F2, then press F9, then press Enter. The cursor will then automatically move down to the next cell, which is the next formula I need to evaluate. I have about 1800 formulated cells that exist in a table that is about 12 columns by 160 or so rows.
I am not sufficiently familiar with excel macros to write one and recording a macro, even using relative cell references, has not proven useful.
Any help???
Thanks!
DB