Originally Posted by
brandoncartwrig
Hello,
I've been trying to copy a formula from one workbook to another workbook, but when I do the formula shows up in the cell instead of its result. The only way I can get the result is to double-click on the cell and then press enter. I've got thousands of these formulas I need to copy and paste. Is there a way to highlight all of them and switch the text to a formula with a few clicks of a button?
The reason I've got to paste the formulas from one workbook to another is quite complicated. I had to create 1000 indirect formulas with absolute references by combining several cells into one and then copying that one cell and pasting the value of it into another.
Bookmarks