MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
I have a table, containing orders from different clients, different items, ordered on different days.
I would like when the users hits the commandbutton, vba should ask for what client (showing a dropdown with all the clients who have ordered).
When the user clicks the client, an invoice is made for that client, just 1 invoice/client regardless the dates the client ordered. VBA should count the amounts together.
An example is attached.
Any help is much appreciated.