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.