Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute Named Ranges????
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!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Named ranges: don't want absolute references | Excel Discussion (Misc queries) | |||
Named ranges: don't want absolute references | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |