Populate Listbox2 based on value selected in ListBox1 with multiple worksheets data

Looking for a help to populated data from listbox1 to listbox2.

When a user enters a text and hit search button the first listbox is listing the provider name with year. There will be multiple years for the specific provider. Let say I am searching “Quba” it will give me to entries as mentioned below.

Al Dar Hospital (Quba) - 2014
Al Dar Hospital (Quba) - 2015

What I need here is when I click on Al Dar Hospital (Quba) – 2015 on listbox2 will list only those batches information from worksheet (Resubmission Adjustment) for example below

Column B Column C Column G
Batch No Date Amount
NB20150929-4945 22-12-2015 25.00
NB20150803-3996 22-12-2015 25.00
NB20150824-4424 22-12-2015 25.00

I hope I have explained my request good to make you understand better.

Sample file is attached worksheets (Output)

Honestly I did not understand what you are asking but I will give a simple example.

I am searching Quba work the first listbox will give me Quba with 2 years (But can be more) then if I select Al Dar Hospital (Quba) - 2014 in listbox1, the listbox2 will show me all the resub batches within that year I.e. 2014 from worksheet Resubmission Adjustment.

if I did not select any thing in listbox1 it will be blank.

I hope I have explained correctly.

sorry about the poor language grammar

thanks for the help let me implemented on my original and get back to you.

Thanks Keeb it works.

Topic marked as solved