ExcelBanter - Validation List

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Validation List (https://www.excelbanter.com/excel-programming/402417-validation-list.html)

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?
--
Thanks for your help.
Karen53

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.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

"Karen53" wrote:

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?
--
Thanks for your help.
Karen53