Does anyone know how to do this?
I want to create 2 listboxes. Each listbox must contain a column from a table that has been imported. Example for the 1st listbox:
288394 CALVIN KLEIN ESCAPE (500mL)
239484 HUGO BOSS (650mL)
874257 JEANPAULG (500mL) ..and so on
The second listbox must contain Cities. (also taken from a table made in excel)
Now, I want to be able to choose a product, choose a specific city, and press a command button so it will direct me to a screen that lets me know how much of that product was ordered or sold in that particular city.
any suggestions ?