Hi - Here's what I want to do:

Link a range of cells in one workbook to a range of cells in another workbook.

Here's what I don't want to do:  Enter 'em one at a time.

Thanks in advance!

---

Request for Question Clarification by rainbow-ga on 16 May 2005 13:57 PDT

Hi goomba_girl,

Is this what you want to do?

http://office.microsoft.com/en-us/assistance/HP051995141033.aspx
(Click on "Create a link between cells in different workbooks")

Looking forward to hearing from you.

Best regards,
Rainbow

---

Clarification of Question by goomba_girl-ga on 16 May 2005 15:58 PDT

Hi Rainbow -

Yep, I'm working with links between workbooks.  In workbook A, there
are 15 contiguous cells containing information which also needs to
appear in 15 contiguous cells in workbook B.  I'm looking for a way to
link all 15 at once.  Does this help?

-- Goomba_Girl :)

---

Request for Question Clarification by livioflores-ga on 16 May 2005 23:08 PDT

What you want is to enter the data in the 15 cells at workbook A and
that data appears automatically in workbook B?

---

Clarification of Question by goomba_girl-ga on 17 May 2005 11:31 PDT

Hi Love2Help --

Huzzah!!  That worked perfectly!!!

Thank you so much!

-- Goomba-girl and her huge spreadsheet  :)

---

Request for Question Clarification by nenna-ga on 05 Jun 2005 14:46 PDT

It seems one of the members of the site answered your question before
a reseacher could. You may want to expire or cancel your question
since it has already been answered. You may still be charged the .50
cent listing fee.

Nenna-GA
Google Answers Researcher

Hi Goomba_Girl,

In workbook A, where you have the 15 contiguous cells containing the
information, select the range by highlighting it.  Goto "Edit" on the
Menu Bar and select "Copy".

Now, switch to workbook B.  Select the first cell of the range (or the
entire range of equal size to that in workbook A) and right click. 
Select "Paste Special", within the Paste Special window, make sure
that "All" is selected under the "Paste" option and "None" is selected
under the "Operation" option.  Then, select the "Paste Link" button. 
That should paste a link from all selected cells in workbook A to the
new range in workbook B.

Also, watch out when relocating the workbooks, the path to the cells
is relative to it's current location.  If you move workbook A,
workbook B's cell links will need to be updated.

I hope this works for you, please let me know if you have questions.

Love2HelpWhenICan

P.S. - Google needs to start accepting additional researcher applications!?!?

love2helpwhenican:  Yes, they do!

You are quite welcome, I'm glad to hear it worked for you!

The original question is not quite clear to me.  There are various
ways to link between worksheets or even from Excel file to a another
Excel file.  Is this to just replicate a worksheet to another
worksheet?

There are also Excel functions like VLOOKUP, RIGHT, LEFT, etc.  If you
are in worksheet named 'Worksheet_A' and you wanna read that's in your
'Workbook_B', you can use =('Worksheet_B'!A1) to read what is in cell
A1.

Why don't you try posting the same question at  http://www.excelforum.com?