How to print a formula

[srmorgan]

Hi,
I have a large file and on one worksheet I have sixteen vlookups. Each one references a different file.
I want to show the name of the file the cell links to somewhere else on the spreadsheet so that anyone else who uses the file knows where the link goes to. Because the paths are long I would prefer to do this by hand.

Because I have so many lookups I want to copy and paste special the whole table that contains the links.

Can anyone give me a suggestion?

I am using Excel 2013

Thank you

 

[DRSteele]

I'm not sure I completely understand what you want, but I can say that function FORMULATEXT will report the contents of any formula. Perhaps you could construct a table on another worksheet by using that function to refer to each cell that is of interest. You could cull from what is reported the relevant parts of the formula to display the file names.

 

[srmorgan]

Thank you, that is exactly what I needed.

SRM

 

[DRSteele]

Super! You're welcome, and Merry Christmas.