How to add the drop down list items selected in another cell

**tshl** · 08-01-2013, 07:50 PM

Hello,

I hope someone can help, I have a sheet that is calculating 2 cells lets say E2 - $F2 and the sum is being Display in cell G2!
So E2 is the starting total. F column is where the users add stock taken. Then G2 is the total minus the units sold.
(This part is working fine!)

My Question is, If I have a data validation drop down list with stock Items, Lets call them Bread, Milk and honey. How can I add the drop down list items selected in another cell.
so at the end of the month bread was chosen on the drop down list 25 times and that number is displayed in cell H2 for example?
(because of privacy my work will not allow me to give a live example - I hope I explained this well enough)

Any help would be greatly appreciated!

**jeffreybrown** · 08-01-2013, 07:55 PM

Hello & Welcome to the Forum,

At least for me I not quite seeing what is desired here...

We understand and respect your company does not want you to transmit privacy information nor do we, but let's say you "make up" a fictitious spreadsheet with a sanitized example so we can get a clearer picture of what you describe and what you desire.

Most times to test a solution we have to try and make up a solution to test so how about you help us help you.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

How to add the drop down list items selected in another cell

LinkBack

Thread Tools

Rate This Thread

Display

How to add the drop down list items selected in another cell

Re: How to add the drop down list items selected in another cell

Thread Information

Users Browsing this Thread

Similar Threads

Drop-down list button, that inserts new row below currently selected cell

Pivot table Query- Top 4 items ignoring selected items from the list

[SOLVED] Apperance of selected items from drop down list in different cell

how do I change height of in-cell drop box list to 12 items

[SOLVED] named range, data validation: list non-selected items, and new added items

Bookmarks

Bookmarks

Posting Permissions