delete list

  • Thread starter Thread starter hans
  • Start date Start date
Yes there is.

Select your sheet.
Then select all.

Then goto data > Validation and then choose any value
 
I have a macro that creates 20 lists from one sheet
row a becoms a list, a1 is the name of the list a2, a3 etc etc are the
choices of a list.
row c becoms a list ,row e becoms a list etc etc
I want to be able to ad values to a list (ad a20 etc)
But i also want to be able to delete row a
the macro creates then new lists
therefor i first have to delet all listnames.

Greetings hans
 
You can have your lists in dynamic range names on a separate page(tab) used
for that purpose only. Put your list name at the top (a1) and the names
starting in (a3) with (a2) hidden. Now create a name the same as the name of
your list.

insert>name>define>name>name it the same as your list name>in the refers to
box type
=offset($A$2,0,0,counta($A:$A)+1,1) enter.
Now for your data validation use =sheet1!yourname
You may now delete names from the lists by right click>delete>shift cells
up( does not delete the whole row). To add, just put the new name at the
bottom (sort if desired) at the bottom. The validation list is now self
correcting. You can even delete the first name because the list is using the
hidden row with just a (touch space bar or use an apostophe)

This should be easier in the long run.
 
Back
Top