Help with parameter

[voix_jomz]

Good day! Im just new with macros so please bear with me. Scenario is I have a database, then I need to pull up the table with columns Invoice, Address, Total etc. based on two parameters CustomerNo and Year. I was able to make it work and no problem pulling up all records. Let's say Cell(2,1) i will type "101" as CustomerNo and Cell(3,1) "2015" as Year, is there a way I can pull up the record if the user will input "2010;2013;2015" for the Year and will generate all records pertaining to those values. I hope someone could help me. Thanks!

[GC Excel]

Let's say the variable is called sInput.
The use

Please Login or Register  to view this content.

This will create an array of the 3 values (2010, 2013, 2015).
The loop through the array to take action on each value :

Please Login or Register  to view this content.

[voix_jomz]

Hello! thank you for the quick reply. code runs like a charm! thanks again!

[GC Excel]

You're welcome! Thanks for the feedback and for the rep.