Update respective cell values in the table based on Multiple Drop Down list selections.

Hello Everyone,

Please help as I am new to Excel as well as this forum.
I have attached simple Excel Sheet where I want to Update respective cell values in the table based on Multiple Drop Down list selections.
I know its very simple for some of you but if you can pass on that knowledge to me it will be great start to my Excel Career!

Solution will be greatly appreciated. Please refer to the attached file.

Thanks in Advance
-Nilesh

sample sales tracker.xlsx

I know you have gotten solutions in your other thread, but I was working on this and got distracted and will post the code any way.

This version of the solutions offered (as currently posted) will accomodate additional names and products that may be added to the table.
There is room for improvement, but it is a start if you want to use it.

Please Login or Register  to view this content.