-
Making Formulas into Words
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules