Hi ...
i have S columns that get the name of sheets in its as this
Column "S"
<tbody>
</tbody>
<tbody>
</tbody>but the problem is with this formula in drop down list all names shown except last name ,which in this case is "Jhon"
and i dont know why
**NOTE: the rows under last name are empty
i have S columns that get the name of sheets in its as this
Column "S"
Jason | |
Tom | |
Brad | |
Hanks | |
Jhon |
<tbody>
</tbody>
and i have in range("B2") drop down list to pick one of the names in columns "S" |
and in drop dwon i have this formula |
=OFFSET(C1,0,0,COUNTA(s:s)-1) |
<tbody>
</tbody>
and i dont know why
**NOTE: the rows under last name are empty