<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>Good day all<o
></o
>
<o
></o
>
I was wondering if anybody would be able to assist me with a complax excel problem. I am a quality assessor and I assess various products which each have there own requirements and mark points. The formula I'm looking for is to be able to select, by a drop down box, the product and the criteria I use to assess that product to populate on a certain cell. Ill give you an simple example<o
></o
>
<o
></o
>
The product is a pre paid contract<o
></o
>
The criteria could be the following:<o
></o
>
Was the product sold today<o
></o
>
Was it sold via tel,email or fax<o
></o
>
Was an attempt made to offer the customer a contract<o
></o
>
<o
></o
>
Now each of these points have a weighting namely out of 5 they sales person could get anything between 1-5<o
></o
>
<o
></o
>
The info I need will need to populate to Cells A3 to L7. this area of Cells is where all the info will need to be populated to. What I also would like is to have this info populate and have the sales person be able to edit certain fields. So if I select Prepaid in the drop down box, the assessment sheet for prepaid should populate and be editable <o
></o
>
<o
></o
>
This is a complex sheet and I know it is a lot to ask for but I would be extremely grateful for any assistance with regards to the above problem<o
></o
>
<o
> </o
>
Thanking you I advance<o
></o
>






<o


I was wondering if anybody would be able to assist me with a complax excel problem. I am a quality assessor and I assess various products which each have there own requirements and mark points. The formula I'm looking for is to be able to select, by a drop down box, the product and the criteria I use to assess that product to populate on a certain cell. Ill give you an simple example<o


<o


The product is a pre paid contract<o


The criteria could be the following:<o


Was the product sold today<o


Was it sold via tel,email or fax<o


Was an attempt made to offer the customer a contract<o


<o


Now each of these points have a weighting namely out of 5 they sales person could get anything between 1-5<o


<o


The info I need will need to populate to Cells A3 to L7. this area of Cells is where all the info will need to be populated to. What I also would like is to have this info populate and have the sales person be able to edit certain fields. So if I select Prepaid in the drop down box, the assessment sheet for prepaid should populate and be editable <o


<o


This is a complex sheet and I know it is a lot to ask for but I would be extremely grateful for any assistance with regards to the above problem<o


<o


Thanking you I advance<o

