I need help with excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2678424%22%20slang%3D%22en-US%22%3EI%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2678424%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20working%20on%20an%20excel%20sheet%20and%20I%20have%20an%20issue%2C%20I%20need%20to%20do%20something%20but%20I%20dont%20know%20how%20to%20do%20it%20or%20if%20it's%20possible%20with%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20good%20at%20English%20so%20I%20hope%20you%20guys%20can%20understand%20what%20I%20mean...%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20do%20a%20Supplier%20evaluation%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20identify%205%20criticals%20point%20those%20need%20to%20be%20evaluate%20individually%20(from%200%20to%202)%20and%20i%20need%20to%20have%20a%20final%20score%20(from%200-10).%3C%2FP%3E%3CP%3EI%20need%20to%20have%20a%20cell%20that%20show%20the%20final%20score%20(0-10).%26nbsp%3B%3C%2FP%3E%3CP%3EI%20set%20my%205%20criteria%20on%205%20cells%20and%20create%20a%20scrolling%20menu%20with%20the%20possibility%20to%20choose%20from%200%20to%202%3C%2FP%3E%3CP%3Eand%20a%20final%20cell%20with%20the%20sum%20of%20those%20number.%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20is%20it%20possible%20to%20implant%20those%20on%20a%20single%20cell%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3Ea%20cell%20when%20i%20click%20on%20show%20me%20those%20criteria%20and%20iam%20need%20to%20be%20able%20to%20choose%20a%20number%20for%20each%20and%20at%20the%20end%20the%20cell%20only%20show%20the%20final%20result%3F%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20some%20can%20help%20me%20and%20hope%20you%20guys%20can%20understand.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20french%20speaking%20so....%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20reading%26nbsp%3B%3C%2FP%3E%3CP%3E%3CLI-EMOJI%20id%3D%22lia_red-heart%22%20title%3D%22%3Ared_heart%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2678424%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2679164%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2679164%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1136042%22%20target%3D%22_blank%22%3E%40benjkow%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20it%20possible%20to%20provide%20small%20sample%20file%20which%20illustrates%20what%20exactly%20you'd%20like%20to%20receive%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2679282%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2679282%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20answer.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20drop%20the%20file%20here.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20have%20the%20table%20At%20I4-J10%20insert%20in%20the%20cell%20D5.%20When%20I%20click%20on%20the%20cell%20it%20will%20show%20me%20this%20table%20that%20i%20need%20to%20fill%20and%20at%20the%20end%20just%20show%20the%20final%20sum%20at%20cell%20J10%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, 

I'm working on an excel sheet and I have an issue, I need to do something but I dont know how to do it or if it's possible with Excel. 

I'm not good at English so I hope you guys can understand what I mean... 

I'm trying to do a Supplier evaluation sheet. 

I have identify 5 criticals point those need to be evaluate individually (from 0 to 2) and i need to have a final score (from 0-10).

I need to have a cell that show the final score (0-10). 

I set my 5 criteria on 5 cells and create a scrolling menu with the possibility to choose from 0 to 2

and a final cell with the sum of those number. 

Now, is it possible to implant those on a single cell ? 

a cell when i click on show me those criteria and iam need to be able to choose a number for each and at the end the cell only show the final result? 

Hope some can help me and hope you guys can understand. 

I'm french speaking so.... 

Thanks for reading 

 

 

3 Replies

@benjkow 

Is it possible to provide small sample file which illustrates what exactly you'd like to receive?

@Sergei Baklan 

Hi, 

Thanks for the answer. 

I drop the file here. 

Is it possible to have the table At I4-J10 insert in the cell D5. When I click on the cell it will show me this table that i need to fill and at the end just show the final sum at cell J10 ? 

Thanks a lot 

 

@benjkow 

Thank you. If I understood correctly

 

- you click on the cell

- pop-up window appears in which you select some items

- you click Ok, calculated sum for selected items is returned to the cell.

 

Afraid that's with VBA programming. Sorry, but not my competency, perhaps someone else could help.