List

  • Thread starter Thread starter Victoria_Wells
  • Start date Start date
V

Victoria_Wells

I want to create a list with drop down arrows, however, I want to incorporate
more than 1 column of datat and I do not want it to
limit how many items I can select. I type the same data day in day out, so I
want to create a list of this data, so I can just select the items I need
each time, rather than having to type them over and over but including more
than one olumn is imperitive - any ideas??
 
Answered your question earlier.

(e-mail address removed)


Gord Dibben MS Excel MVP
 
Hi there
Will this work for multiple columns as I can only seem to get it to work if
I use one column?

Many thanks
 
Not that I know of.

You can have a DV list for a column or a row but not multiples of same.

Best to copy all to one column on a new worksheet.

Create a named range for that list then in DV>Allow>List enter =MyList(if
that's the name you gave it)


Gord
 
You must log in or register to reply here.

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

Lists 1
Drop down/data validation list 5
How to create a bubble chart with more than 2 variables 0
Excel Help to copy information from one row at a time to another sheet 1
Selection of drop down list directs auto population of other cell 1
How to Update drop-down list? 5
drop down list should remember selection. 6
How do I link 2 drop down list together? 1

Back
Top