Drop Down List

N

nntp.aioe.org

I have tried to make things easier for co-workers by creating several drop
down list's. The attempt was to allow them to go to the cell in question,
select the down arrow and choose the item to be inserted. But, as things
happen, they either add/delete rows/columns and destroy the data for the
drop down. At the present time, I have them hidden in column a. The
question is, what would be a "safe" non erasable area to store the data in,
any experience??? Tx
 
L

L. Howard

Maybe make your list/s on a sheet and use named ranges in the source box of DV.

So on sheet 3 I have a list and I named it HydeMe.
On sheet 1 in the drop down > allow > List > source window > =HydeMe.

Then hide sheet 3.

Regards,
Howard
 
W

wabbleknee

Tx. Will try that and see how well it works. :)

"L. Howard" wrote in message

Maybe make your list/s on a sheet and use named ranges in the source box of
DV.

So on sheet 3 I have a list and I named it HydeMe.
On sheet 1 in the drop down > allow > List > source window > =HydeMe.

Then hide sheet 3.

Regards,
Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop down list 1
Drop-down list and error message 1
Chart Title change with Drop Down Selection 2
Drop down list from index/match formula 1
Data Validation and drop-down list using IF, AND and what else? 8
Drop Down List Help 4
Drop down list hyperlink 4
Using a drop-down box to sort data based on seperate columns 2

Top