Hello,
I need help with a sub that that will copy a name from selected drop down list and paste it to a designated cell , but if the cell is not blank then paste on the next cell down if blank, if not then next down...ect. to a range of 15 cells.

hi,

a "drop down list" can be a ComboBox control or a data validation list
or a ComboBox form, what is yours?

isabelle

Le 2013-01-30 12:22, escelnewbie a écrit :

Hello,
I need help with a sub that that will copy a name from selected drop
down list and paste it to a designated cell , but if the cell is not
blank then paste on the next cell down if blank, if not then next
down...ect. to a range of 15 cells.

It is Data Validation.

there is a possibility to use the Calculate event. What is the address
of the data that feed the validation list? i hope that this data is on
another sheet.

isabelle

Le 2013-01-31 09:56, escelnewbie a écrit :
isabelle;1609020 Wrote:
hi,

a "drop down list" can be a ComboBox control or a data validation list
or a ComboBox form, what is yours?

isabelle

Le 2013-01-30 12:22, escelnewbie a écrit :-
It is Data Validation.

Yes the list "rostername" is approx 250-300 names on a seperate sheet. I can get it to select the name from drop down list, but I cannot figure out how to go to next empty cell with out referencing itself.