UserForm ListBoxes Dependant Selections

[crashing1912]

Hi All,

I am creating a couple of listboxes for my users. The first listbox is a list of clients. The second list is a list of projects. I have a separate macro running to copy and paste some data depending on the users' selections. I need to give the users the ability to run either a client report or a project report, hence the two listboxes and separate command buttons. Since, my project list is pretty long I was wondering if there was a way to let the users narrow the results in the project list listbox based on their selection from the client listbox.

My listboxes are using the RowSource property from two columns in sheet1:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Client Listbox Values
[/TD]
[TD]Project Listbox Values
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]1234
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]12345
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]123456
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]1234567
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]4321
[/TD]
[/TR]
</tbody>[/TABLE]

Also, the list is dynamic. The list above is based on an index match to obtain just the unique values from the data, so if I could incorporate a way to ignore the blank cells/"" results from the index match, that would be helpful.

Thanks!