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!!
Bookmarks