How to update particular cell according to Drop down list selection?

**nileshpatil** · 09-16-2012, 07:55 AM

Please some help me with this problem, I have complete mental block at the moment.
what I am trying to achieve it seems very easy but cant get my head around it...

1.User will select Sales Person Name from drop down list
2.User will select Product Sold by Sales Person
3.User will add Quantity manually
4.User will click Add Button...
5.Table should be updated accordingly - Quantity should be added to existing cell value
e.g. 'David' has Already sold 4 'HTC XL' and as per current selection the Total in Cell D6 should change to '5'

Please refer to attached Excel Document.
sample sales tracker.xlsx

**Jakobshavn** · 09-16-2012, 08:28 AM

See attsched

**stanleydgromjr** · 09-16-2012, 08:41 AM

nileshpatil,

Welcome to the Excel Forum.

Detach/open workbook CMDButton ADD - sample sales tracker - nileshpatil - EF860803 - SDG15.xlsm and make some selections from the two drop downs and add a valid number into cell D3 and click on the Add button.

**Cutter** · 09-16-2012, 08:49 AM

Hello nileshpatil, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Original thread here: http://www.excelforum.com/excel-form...elections.html

Thread Closed.