PDA

View Full Version : Making Formulas into Words



MachaMacha
12-24-2007, 09:16 AM
I have one worksheet of a bunch of formulas and the results are displayed as the computed numbers

I would like a macro that can create a new worksheet and for every cell that is a formula copy the formula as text, as shown in the attached jpeg

I will have a lookup table that has a label for each column

I would like a column in the sheet that transcribes the R1C1 formula to words using the lookup table

For Example
The first copied over text formula is '=H16 * E16 * $E$9
I would like the column next to it, using the lookup table, to say
'=asset3(row 16) * asset (row16) *$$asset(row9)

Thanks in Advance