Hi
I haven't been able to figure this out ... probably dumb but here goes.
I want to have a dropdown list of all of the names listed in the cells of a
sinlge column. I don't want to change anything in the cells but rather I
would like the person using the worksheet to be able to click at the top of
the column and select a name from the list after which they are directed to
each of the entries corresponding to that name in that column. Thanks,
Data-gt;Filter-gt;Autofilter
Should work. You will need a header row for this to work properly.
quot;AJquot; wrote:
gt; Hi
gt;
gt; I haven't been able to figure this out ... probably dumb but here goes.
gt; I want to have a dropdown list of all of the names listed in the cells of a
gt; sinlge column. I don't want to change anything in the cells but rather I
gt; would like the person using the worksheet to be able to click at the top of
gt; the column and select a name from the list after which they are directed to
gt; each of the entries corresponding to that name in that column. Thanks,
gt;
gt;
- Oct 05 Fri 2007 20:39
Drop down list for a single column
close
全站熱搜
留言列表
發表留言