drop down lists/validation tables

I have a worksheet with 6 columns, in each, I want to create a list that I can pick from. Example, column A would be Sales Rep. When I get to cell A2, I want a drop down list that has all of my reps in it. I can then pick the rep from the list and it populates in the target cell. Same scenario for the other columns.

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>

Look at Data Validation feature.

Alok

"mkingsley" wrote:

>
> I have a worksheet with 6 columns, in each, I want to create a list that
> I can pick from. Example, column A would be Sales Rep. When I get to
> cell A2, I want a drop down list that has all of my reps in it. I can
> then pick the rep from the list and it populates in the target cell.
> Same scenario for the other columns.
>
>
> --
> mkingsley
> ------------------------------------------------------------------------
> mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
> View this thread: http://www.excelforum.com/showthread...hreadid=397923
>
>