Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 64
Default Link Cell to cell in different file

I have 2 x files, i.e. "1.xls" & "2.xls". I want cell C3 in the file 1.xls to
reflect the data that I have entered in cell C3 of the file 2.xls. How do I
do this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default Link Cell to cell in different file

1) Open BOTH WB.
2) In cell C3 of WB1 type = [equal sign] with your mouse(!) move to WB2
CLICK on cell C3 and Press Enter.
Micky


"WildWill" wrote:

I have 2 x files, i.e. "1.xls" & "2.xls". I want cell C3 in the file 1.xls to
reflect the data that I have entered in cell C3 of the file 2.xls. How do I
do this?

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
Using UNC path instead of URL to link cell to PDF file Francisco Excel Worksheet Functions 2 May 24th 07 10:30 PM
Is it possible to link cell formatting in Excel from file to file KimW Excel Discussion (Misc queries) 4 August 17th 06 07:03 PM
How can I link external file cell formats? Peter Excel Worksheet Functions 0 June 27th 06 04:53 PM
How can I link a pdf file (address) to an Excel cell Wil Excel Discussion (Misc queries) 1 April 28th 06 10:38 AM
link cell content to another file blackstar Excel Discussion (Misc queries) 2 April 4th 06 03:20 AM


All times are GMT +1. The time now is 10:55 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"