I have a spreadsheet the lists current projects and employees working on that
project. It also contains calculations to calculate how many employees are
on the site, how many more needed, how many extra are on site, etc. The
formula contains named ranges for each category of emp


Job ABC = project 21
SMEmployees = named range SME21
SMAEmployees = named range SMA21
etc.

My problem is that the people using the spreadsheet drag the name around
from project to project and it seems that it is screwing up the references
for the named ranges and in turn screwing up the formula. Is there a way to
set the ranges as absolute. I have asked them to copy and paste, but it is
beyond them.

Thanks for any help you can provide!!!!!