Create a list menu In a Column

Does anybody know how to create a macro that will create a dropdown option in Column E for all rows with information starting in row 2. The dropdown options would Include(Import, Transfer). The amount of records will vary so the a set number of rows that the dropdown options would run to is unknown. So the best option would to run the macro until it finds 2 empty rows in a row in Column B. Thanks for your help.

No macro necessary. Use a dynamic named range. Create a range called Values with a Refers To value of

Formula:

Please Login or Register  to view this content.

Then in the cell for your dropdown, use data validation and create a List with a Source of "=Values".

But what if i wanna put it in a loop?

I'm confused. Are you wanting it to create multiple dropdowns in x number of rows, or are you wanting the data source for a single dropdown to be a list with x number of rows?

Multiple Dropdowns.

In that case, use data validation to create your dropdown in the first cell. Then just drag it down to as many rows as you need. If you still need to do it with code, then this would do it:

Please Login or Register  to view this content.