Link to specific cell in specific Excel file
the simplest way is to be in the cell you want the link to show up enter =
and go to the book and sheet you want and select the cell.
you will end up with something like
='[New_Excel_File]Sheet3'!C312
the advange to using the moue to just typing it in is that if you make as
many typos as I do, you won't have to retype it as often.
another method is to goto the cell you wnt to link to in the new file, copy
it, go to where you want the data to show and paste special link.
"JeroenM" wrote:
Hello,
I want to make a link from a cell in a worksheet to a specific cell (let's
say C:312 in worksheet "Sheet3") in another specific Excel file (let's say
New_Excel_File.xls).
How can I do that?
Thanks, JeroenM.
|