Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to specific cell in specific Excel file
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to specific cell in specific Excel file
Hi,
Do the followinf: 1. Select the cell in the first sheet. 2. On the Edit menu, click copy 3. To move to your next excel file press ALT+Tab. Note: AlT+Tab only works if you have two different Work book. However, to select different sheet with a Workbook, you have click the Windows menu. 4. Click to select cell locaton. 5. On the Edit menu, click Paste Special. 6. In the Paste Special dialog box, click Paste link. In the formual bar, you will notice the Source file path and cell refernce with "$" symbol. This represents the absolute reference link to your source location. 6. Click OK. Challa Prabhu "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Link to specific Sheet in external excel file | Excel Discussion (Misc queries) | |||
Create a non-specific file link | Excel Discussion (Misc queries) | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) |