VBA to select specific Text in Drop Down List

**woolen** · 04-13-2012, 05:04 PM

Hello. I am trying to figure out the VBA to select specific values in a drop down list already created in my spreadsheet.

What I am doing overall: I have a drop down list of six cities (in C5) that triggers the re-calculation of cell D18 (which is sales for that particular city). I need a macro that selects the cities one at a time, then copies the sales value for each one in D18, then pastes the values in a different sheet that I named "Datos".

I recorded a macro manually and got the following VBA, but it does not differentiate when I selected something different in the drop down list. Please help!!

Please Login or Register  to view this content.

**dominicb** · 04-13-2012, 05:22 PM

Come on woolen. You've got enough posts to your name to know the rules.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

DominicB