Debra Dalgleish has instructions:
http://contextures.com/xlDataVal05.html

It may be easier to just copy|paste the lists into each workbook when the
workbook opens???

KarenF wrote:

Hi.

I have a spreadsheet with a several dynamic lists (ranges created using the
offset formula.) which I am using for data validation. Several people using
several different files need to be able to reference these lists as their
data is validated by them. For this to work, I know that every individual
needs to have the list file open while they work on their validated sheets.
I had thought about creating a master list file, which, if updated, could be
copied and pasted into a list file for each individual. The individual's
list file would need to open when they open their validated workbook, and
would need to be updated when the master list was updated (I thought about
recording a macro to copy and paste the master lists' data into the
individuals' lists which would be run by each individual when they were
informed that the master file had changed - thus relying on anyone editing
the master file to inform the team). The team require that anyone can update
the master list file, and their individual files be based on the list. Any
ideas would be greatly appreciated.

Thanks very much.

Karen

--

Dave Peterson