dropdown menu accross row data as list fill range

B

Bere

Hi, i create a dropdown menu,
but as a list fill range i put a row like A1:Z1
then the dropdown menu only shows me the first value as if it is only
working for data arranged in a column

Is there a way to do it with data in a row?
Thanks in advance
 

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

Unique Dropdown menus 1
capture filter values from a sheet into a dropdown list in userfor 3
Concatenate a row that is selected and include blank cells 11
Associating data for auto fill in from dropdown list 2
Combobox filtering 2
Transfer data between two worksheets 10
Macro jumps to combobox 3
Capture Filter 'AfterUpdate' event in Pivot Table 3

Top