Complex Formula

[Msdtitus]

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

 

[Trevor G]

Please dont double post,

Look at using a VBA userform so the people can interface with that allowing drop downs and options from the drop downs to be made, populating worksheets can be done through this method.

If you have permission you can watch tutorials on YouTube

Also look at this link

http://www.contextures.com/xluserform01.html

 

[Msdtitus]

Maybe im just being blond. I have a pre-made assessment sheet so would I be able to populate this using a user form and could you give me direction as to how this can be done?

I went into the site provided and German is what it looks like to me lol. I am reading it now to try and understand it but any assistance on where to start would be greatly appreciated.

Thank you for the assistance thus far and any future assistance offered

 

[Msdtitus]

Maybe im just being blond. I have a pre-made assessment sheet so would I be able to populate this using a user form and could you give me direction as to how this can be done?

I went into the site provided and German is what it looks like to me lol. I am reading it now to try and understand it but any assistance on where to start would be greatly appreciated.

Thank you for the assistance thus far and any future assistance offered

Hi everyone, is there anyone who can assist me or give some direction as to how to populate the information using a user form

 

[VBACO]

The website supplied broke it down pretty well. If you cannot use that you may not be ready to delve into this project.