Advertisement

05.02.2007 at 08:31AM PDT, ID: 22547848
[x]
Attachment Details

Auto-populate cells based on user selected item in drop-down list

Asked by didier0315 in Microsoft Excel Spreadsheet Software

Tags: excel, populate, auto

I have a drop down list of sales teams within my company.  I have two cells that I would like to auto-populate based on the team selected in the drop down list.  Essentiallys if Team A is selected  I'd like to have A1 auto-populate with "LocationA" and B1 auto-populate with "JobNumberX".  The information stays static, meaning the job number for Team A is always the same.  I have two columns with the information I want to use to auto-populate those cells I'm just not sure of the easiest way to do this.  I'm using Excel 2003 for this.  Any assistance would be greatly appreciated.Start Free Trial
[+][-]05.02.2007 at 08:36AM PDT, ID: 19016783

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: excel, populate, auto
Sign Up Now!
Solution Provided By: patrickab
Participating Experts: 3
Solution Grade: A
 
 
[+][-]05.02.2007 at 08:38AM PDT, ID: 19016801

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2007 at 09:10AM PDT, ID: 19017087

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.02.2007 at 12:25PM PDT, ID: 19018544

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2007 at 03:30PM PDT, ID: 19019831

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2007 at 03:49PM PDT, ID: 19019906

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2007 at 03:57PM PDT, ID: 19019935

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2007 at 04:14PM PDT, ID: 19020015

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2007 at 04:25PM PDT, ID: 19020058

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2007 at 04:27PM PDT, ID: 19020071

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.03.2007 at 05:00AM PDT, ID: 19022403

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32