Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Link to specific Sheet in external excel file cmceng14 Excel Discussion (Misc queries) 1 January 16th 07 06:23 PM
Create a non-specific file link Seth Excel Discussion (Misc queries) 0 August 25th 06 02:16 PM
Link from a specific Cell in Excel to a specific para. in Word CathyK Excel Worksheet Functions 0 August 10th 06 04:40 PM
Highlight a row if a specific cell is specific numbers/words sea0221 Excel Worksheet Functions 2 March 9th 05 01:06 AM
How do I make a cell date specific to input a value on a specific. ebuzz13 Excel Discussion (Misc queries) 1 January 18th 05 06:53 PM


All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"