software

Is it possible to create a conditional drop down list in Excel.

For example, in cell A1, I have created a drop down list for Sales
Representative. In cell A2, based conditionally on what sales rep was
chsoen from the drop down list in cell A1, I want another drop down
list for Customer. Depending on the Sales Rep chosen in cell A1, the
drop down list in cell A2 will vary.

Any help would be greatly appreciated.

Thanks,

Bogo--
Bogo
------------------------------------------------------------------------
Bogo's Profile: www.excelforum.com/member.php...oamp;userid=31634
View this thread: www.excelforum.com/showthread...hreadid=513267Hi Bogo,

Take a look here. If you can't make it work for you, send me an e-mail and
I will send you a workbook with an example set up for you.

www.contextures.com/xlDataVal01.html

HTH
Regards,
Howard

quot;Bogoquot; gt; wrote in message
...
gt;
gt; Is it possible to create a conditional drop down list in Excel.
gt;
gt; For example, in cell A1, I have created a drop down list for Sales
gt; Representative. In cell A2, based conditionally on what sales rep was
gt; chsoen from the drop down list in cell A1, I want another drop down
gt; list for Customer. Depending on the Sales Rep chosen in cell A1, the
gt; drop down list in cell A2 will vary.
gt;
gt; Any help would be greatly appreciated.
gt;
gt; Thanks,
gt;
gt; Bogo
gt;
gt;
gt; --
gt; Bogo
gt; ------------------------------------------------------------------------
gt; Bogo's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31634
gt; View this thread: www.excelforum.com/showthread...hreadid=513267
gt;
if you are starting with a database highlight all and use Datagt;Filtergt;Auto
filter
click on any of the arrows to sort the data by category.

quot;Bogoquot; wrote:

gt;
gt; Is it possible to create a conditional drop down list in Excel.
gt;
gt; For example, in cell A1, I have created a drop down list for Sales
gt; Representative. In cell A2, based conditionally on what sales rep was
gt; chsoen from the drop down list in cell A1, I want another drop down
gt; list for Customer. Depending on the Sales Rep chosen in cell A1, the
gt; drop down list in cell A2 will vary.
gt;
gt; Any help would be greatly appreciated.
gt;
gt; Thanks,
gt;
gt; Bogo
gt;
gt;
gt; --
gt; Bogo
gt; ------------------------------------------------------------------------
gt; Bogo's Profile: www.excelforum.com/member.php...oamp;userid=31634
gt; View this thread: www.excelforum.com/showthread...hreadid=513267
gt;
gt;