excel - Using Drop Down Lists -


i new vba working loops. trying create "do until (or while)" loop pulls drop down list in excel, , once pulls correct data drop down, continue proceed on other columns right of drop down. in current statement below, need add 'if' statement or other type of procedure process? can me understanding of how works , coding on right track?

sub main_territories()  range("c23").select   until activecell.value = ""   if territories = 1       territories_1 = activecell.value   elseif territories = 2 exit       territories_2 = activecell.value   else       territories_3 = activecell.value   end if  territories = territories + 1 activecell.offset(1, 0).select  loop end sub 


Comments