<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><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>
fficeffice" /><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>
