P
purpletigerface
Hi
I've created named dropdown lists for data validation which are on a separate
worksheet. They worked fine until I tried to add to them. For example I have
a list named 'Years', which I have added a few years to. I can't seem to
redefine the name 'Years' to include the extra items. I've tried highlighting
the whole list and renaming it 'Years' but it just reverts to the old section
of the list. I can't change the source range in the Data - Validation box, as
this shows the list name, not the souce range. Anyone know how I do this?
Thanks
Karen
I've created named dropdown lists for data validation which are on a separate
worksheet. They worked fine until I tried to add to them. For example I have
a list named 'Years', which I have added a few years to. I can't seem to
redefine the name 'Years' to include the extra items. I've tried highlighting
the whole list and renaming it 'Years' but it just reverts to the old section
of the list. I can't change the source range in the Data - Validation box, as
this shows the list name, not the souce range. Anyone know how I do this?
Thanks
Karen