Hi,

I need a solution to the following problem.

I have a template for each member of staff [e.g John Doe Time Tracking.xls]
(for about 50 people) to track time spent on particular activities (projects)
and which company they are employed by.

Because the lists of Companies, Projects and EMployment Status may change
from time to time, I would like to maintain this in a centralised spreadsheet
rather than in each of the 50 worksheets that each member of staff uses.



So on every template, I would like the following:

Cell: $F$5 to select from Range A1:A6 in Lookup.xls'Organisation'
Cell: $F$6 to select from Range A1:A3 in Lookup.xls'Employment Status'
Cells: $L5:$L100 to select from Range A1:A12 in Lookup.xls'Projects'



Is there a simple way of doing this so that the variables can be held and
maintained in a seperate excel file?

Regards

Sharon