Multiple selection from list box

[farhadj]

Good Day

I have this spreadsheet whereby access cards are issued to staff.

The spreadsheet also calculates the stock of cards at the same time.

How the issuing of cards works is as follows:. For new staff member 2 access cards (1xALB - 1x KOP) , 1 card holder and 1 lanyard issued.

MY spreadsheet has the option of selection multiple items in the listbox, however this does not calculate the running stock balance.

However is I select each item individually from the ListBox the stock is calculated.

I would like the stock to be calculated by selecting all the items selected in the list box

I have attached the spreadsheet for clarity.

[tyrel9]

Place a * in front and ending of your text string on the Stock Inventory Tab. This will look for the text in the entire string from your criteria field. Tested it and it seemed to have worked.

*ALB*
*KOP* (change to KOP to match multi criteria field.)
*HOLD*
*LAN*
*DAM*

Hope this works out!

[farhadj]

Hi tyrel9

Thanks a million for your help. It worked as I wanted it to.
Once again thanks a million
God Bless you.
Regards