Link to specific cell in specific Excel file
Open both files and arrange the file windows so that both are visible
on screen at the same time. Then with your cursor in cell C312 of
Sheet3, type the equals sign then click on the other file window and
sheet tab and cell where you want the data to be brought from. Then
just press the <Enter key and the formula (with the correct syntax)
will have been built up for you in the first file. If you close the
New_Excel_file window, then the formula will expand to include the
path.
Hope this helps.
Pete
On Jul 5, 1:28 pm, 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.
|