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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|
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 06: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 |