close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()