A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking multiple cells efficiently



 
 
Thread Tools Display Modes
  #1  
Old February 1st, 2006, 04:05 AM posted to microsoft.public.excel.links
external usenet poster
 
Posts: n/a
Default Linking multiple cells efficiently

I have Excel 2002 and would like to link 2 columns across 2 workbooks. I
know how to link the cells across workbooks one at a time, but I am wondering
if there is way to link columns at time. for example:

In the following example, I could first link 1a to 1b, then 2a to 2b then
3a to 3b. Is there a way for me to select the cells 1a:3a in workbook 1 and
directly link them to cells 1b:3b in workbook 2

workbook 1 workbook 2
1a -- 1b
2a -- 2b
3a -- 3b

Hope someone can help. Thanks

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding separate accumulators for multiple cells jrambo63 New Users 1 May 26th, 2005 06:56 PM
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell Tourcat Worksheet Functions 1 February 8th, 2005 07:26 PM
Linking cells to MS Project cells Bob General Discussion 0 July 26th, 2004 05:51 PM
Linking Text cell comments to cells on other sheets in same book. Cpl Bowen Worksheet Functions 8 June 2nd, 2004 02:27 AM
link multiple cells from other workbook on another machine on network Bryce Links and Linking 2 October 13th, 2003 04:58 PM


All times are GMT +1. The time now is 06:59 AM.


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