Validation List

  • Thread starter Thread starter Karen53
  • Start date Start date
K

Karen53

Hi,

I'm not sure I can do this. I have two rows of data, one is F30:N30 and the
other is F36:N36. The cells contain percentages. I need to make a
Validation List drop down in a cell with a combination of both rows for the
user to chose from. Is this possible?
 
If you copy the values next to each other (or beneath each other), you can
form 1 big range. You give it a name, and use that name for your validation
list.
 
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

Data Validation List (conditional) 2
VBA code to run macro in certain file based on name of file in cel 2
I need to change from "=E7" to (equals the current value of E7) 3
Conditional Validation In Excel 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
problems when removing validation 1
A data validation question 1
loop to copy paste 3

Back
Top