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
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