Link all worksheets from Excel file 1 to all worksheets in E

pellacad · Apr 22nd, 2002, 08:27 PM

I need to automatically link all worksheets from one Excel file to another.

Both workbooks contain the same named tabs.

Automating this process would be a tremendous help!

Thank you!!!

Tom Schreiner · Apr 22nd, 2002, 08:52 PM

Hi
If I am understanding you correctly, do the following:

Open both workbooks...

Arrange your windows as is convenient for you..

As a simple example, you were not very specific, lets say you want to link the value of (Book1 Sheet1 Cell A1) to equal the value in (Book2 Sheet3 Cell B1)

in (Book1 Sheet1 Cell A1) type =
then click in (Book2 Sheet3 Cell B1)
and hit enter.
Those two cells, in the two seperate books will now be linked...

Was that what you needed?
If not, please give more details...
Thanks,
Tom

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

Apr 22nd, 2002, 08:27 PM	#1
pellacad New Member Join Date: Apr 2002 Posts: 9	I need to automatically link all worksheets from one Excel file to another. Both workbooks contain the same named tabs. Automating this process would be a tremendous help! Thank you!!!

Apr 22nd, 2002, 08:52 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi If I am understanding you correctly, do the following: Open both workbooks... Arrange your windows as is convenient for you.. As a simple example, you were not very specific, lets say you want to link the value of (Book1 Sheet1 Cell A1) to equal the value in (Book2 Sheet3 Cell B1) in (Book1 Sheet1 Cell A1) type = then click in (Book2 Sheet3 Cell B1) and hit enter. Those two cells, in the two seperate books will now be linked... Was that what you needed? If not, please give more details... Thanks, Tom