Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
BradleyLawrence
 
Posts: n/a
Default Linking Spreadsheets in Excel.

Is there any way to link spreadsheets in Excel, so that a value entered in
Sheet 1 is automatically transferred to Sheet 2?
  #2   Report Post  
Posted to microsoft.public.excel.misc
keithl816
 
Posts: n/a
Default Linking Spreadsheets in Excel.


Hi Bradley,

You could use a formula like =Sheet1!a1

Change cell and sheet name to fit

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=487944

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
i try to open Excel spreadsheets, and they open in wordpad-- mikekeat Excel Discussion (Misc queries) 2 October 1st 05 10:13 PM
Can't print a group of spreadsheets Excel 2003 DebbyD Excel Discussion (Misc queries) 1 August 31st 05 09:10 PM
Linking between spreadsheets does not work unless I have both spr. RCppe Excel Discussion (Misc queries) 2 March 30th 05 12:37 AM
Linking Excel files -- I cannot find an answer anywhere. MAB Excel Discussion (Misc queries) 0 March 28th 05 06:47 PM
Viewing Excel spreadsheets Jimbola Excel Discussion (Misc queries) 1 November 28th 04 06:59 PM


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