external reference to show formula

I'm not sure if this is possible, but I have several workbooks that have formulas in them, and I need to show the values of them. Now I want to have another workbook that shows the formulas of these workbooks. I tried to just show formulas on the second workbook, but then I just get the
Sheet1'!$A$1, but I want it to show the actual formula from the first workbook. Is there any way of doing this without having to redo the formulas in the second workbook?

Hello Snello,

Welcome to the Forum! As a member, you now have full access to the knowledge and posting tools that make this site unique.

In order to provide you with prompt replies to your questions, there are a few rules we ask that you observe. Please remember to follow these rules when you post as a courtesy to your fellow members, and to those who are volunteering their time, and knowledge.

Readability is key in getting a fast response to your question. You have many tools available to assist you in formatting your post. Any code you post, whether a worksheet formula or VBA code should be wrapped. You can find a list of other HTML format options in the forum rules.

How to Wrap your Code
On the Message window Toolbar you will see the # icon. Select the text you want to appear in a Code Window, and Click the # icon. This will wrap the code for you. You can also do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.

You can read the Forum rules by clicking on the link below.
Forum Rules
If you have any questions, contact me by clicking on my name Leith Ross

It sounds like your trying to do this using Formulas. If you want to copy the cell Formula into another workbook as text, the only way I know of to do this is with VBA. Let me know if you want a macro to do this.

Sincerely,
Leith Ross

I would love to get the macro for this! It would save me tons of work.

Ctrl+~ toggles between showing formulas and their results.