You might get a few more replies if you go into more details.

What the formula looks like before the deleting, what it looks like after the
deleting. Where it's located (sheet name and cell address). Range names and
what they refer to (if they're used in the formula).

And what kind of dropdown did you use? Data|Validation, a combobox from the
control toolbox toolbar, or a dropdown from the forms toolbar.

Otto wrote:

I have a spreadsheet used for estimating projects. There are categories
across the top (Electrical Engineering, Mechanical Engineering, etc.). Under
each category are job titles (anywhere from 1 to 9 titles for each category).
Each title has a dropdown list with names of people under that title. The
drop down list of names is converted to the persons initials using an index
formula.

My problem comes when some of the columns (categories and/or titles) are not
used and are deleted or hidden. The formulas in some of the dropdown boxes
change €“ specifically, the input range and the cell link. I am using named
references, but Excel switches the reference in the input range to the name
that was used in the column to the left that was deleted or hidden. I want
the input range to stay the same. I also want the cell link to update to the
new location.

Can anyone help?

--

Dave Peterson