Dear Mr. Excel users!
I have a question and hopefully you can help me with that!
Iam working on a file which should help us evaluate the value of our products based on multiple criteria.
10 people have to fill in a list for each product (40) and value them [1-10]. The total score should be copied to a second tab in to a table (rows = product name header is person 1 2, etc.
for example
Tab 1
Person1 (dropdown box)
product 1 (dropdown box)
criteria 1 -->2
criteria 2 -->5
criteria 3 -->7
criteria 4 -->8 +
====
value 23
When they are finished and filled in all the criteria the should save the score (button save)
The value 23 had to be copied to the following table.
A B C D E F
1 col 1 col 2 col 3 col 4 etc
2 Product 1 23
3 Product 2
4 Product 3
When all colleagues have evaluated the products and valued the products based on the criteria I will make a summery and reevaluate the prices of the product.
I hope you can help!
I have a question and hopefully you can help me with that!
Iam working on a file which should help us evaluate the value of our products based on multiple criteria.
10 people have to fill in a list for each product (40) and value them [1-10]. The total score should be copied to a second tab in to a table (rows = product name header is person 1 2, etc.
for example
Tab 1
Person1 (dropdown box)
product 1 (dropdown box)
criteria 1 -->2
criteria 2 -->5
criteria 3 -->7
criteria 4 -->8 +
====
value 23
When they are finished and filled in all the criteria the should save the score (button save)
The value 23 had to be copied to the following table.
A B C D E F
1 col 1 col 2 col 3 col 4 etc
2 Product 1 23
3 Product 2
4 Product 3
When all colleagues have evaluated the products and valued the products based on the criteria I will make a summery and reevaluate the prices of the product.
I hope you can help!
sorry
