Advance Filters AND criteria populated from selected items in listboxes

[Lenna]

Hello,

There are three list boxes on a sheet(Instruments,Months,Years). After the user selects items in each list box, selected items from each list box are copied into arrays and outputted into corresponding columns to be used as AND criteria for an Advanced filter. This set up works only when the user selects equal number of items from each listbox. The problems arise when the user doesn’t select an equal number of Listboxes and the Advance filter fails, because all of the expressions need to be in the same row for implicit And operator to combine the expressions. Please suggest how to fix this problem using Excel VBA?

Thanks for your help in advance

InstrumentSN(criteria)	Value	Month	Year
LX124R		Jun	2015
HDR345		Aug
UD4566
InstrumentSN(data)	Value	Month	Year
LZ124R	34.23	Jun	2015

<tbody>
</tbody>

 

[Lenna]

Clarification:

Top table shows the output from listboxes. The bottom table represent the correct criteria for advanced filter that i need to configure from the listboxes output. any advice would be Greatly appreciated. Thanks

InstrumentSN	Value	Month	Year
XDF1234		Jun	2015
GR12345		Jul
RW2345
InstrumentSN	Value	Month	Year
XDF1234		Jun	2015
GR12345		Jun	2015
RW2345		Jun	2015
XDF1234		Jul	2015
GR12345		Jul	2015
RW2345		Jul	2015

<tbody>
</tbody>