Hi

To avoid problems with linked workbooks (An Excel file as MM source for Word
is linked too) keep all such workbooks on some shared network resource (on
some server, I'll advice). All users who need to link to such workbooks,
have to map this network resource - preferably all with same drive letter
(p.e. X)

Now, all links to those workbooks will be like
'X:\Sources\[SourceWorkbook.xls]SheetName'!A1 - for every user.
Whenever you migrate this network resource to some new location, all users
have to remap it with same drive letter again, and all links will work
without any problems.


Arvi Laanemets


"Neon520" kirjutas sõnumis news:
...
Hi everyone,

Purpose: create classroom roster between one Excel spreadsheet as data
source and another excel sheet.

I know how to use one excel spreadsheet as a data source to merge with
another word document; however, by using this method, I found that the
link
between the files keep dropping from time to time, especially when the
folder
has been moved around.
I'm thinking of creating the same layout of the Word document in another
Excel spreadsheet and somehow "LINK" the data source and the other
spreadsheet together, but I'm not sure how, or whether this is even
possible.
I'm thinking of using Vlookup or Hlookup, but this function only return
one
result and I'd like the function to return multiple result based on the
look
up criteria.

Please find my data source layout below:
First Name | Last Name | Days | Classroom | DoB ...

As you may notice that "Classroom" column will contain repeated
information,
and if I choose this as the look up criteria in Vlookup or Hlookup, the
function only return one result. And that's not the whole roster for that
particular classroom.

Is there anyone who have done this sort of thing before?
Is this possible to do in Excel? I'm using Excel 2003.

Thank you,
Neon520