Linking more than one cell at a time

Bryan James · Apr 25th, 2002, 01:33 PM

I am trying to link information from one workbook to another. I know how to set the cell on one workbook to update the selected cell in another workbook by simply assigning an = sign in that cell and entering the corresponding cell ID. My problem is that I want to do this for over 2000 cells and they each will correspond to they same cells in a different workbook. Is there a way to do this without having to enter the formula for each cell over and over?

Mudface · Apr 25th, 2002, 01:51 PM

Try Copy- Paste Special- Paste Links, does the same thing.

Apr 25th, 2002, 01:33 PM	#1
Bryan James Board Regular Join Date: Apr 2002 Location: Richardson, TX Posts: 59	I am trying to link information from one workbook to another. I know how to set the cell on one workbook to update the selected cell in another workbook by simply assigning an = sign in that cell and entering the corresponding cell ID. My problem is that I want to do this for over 2000 cells and they each will correspond to they same cells in a different workbook. Is there a way to do this without having to enter the formula for each cell over and over? __________________ Bryan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 01:51 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Try Copy- Paste Special- Paste Links, does the same thing.