Hi!
I have a small problem where I'm creating a database and a separate excel file for doing calculations with values found in the database. Since the database is in another file I want to minimize reading from that file to improve performance, so I read the database once and put everything into an array. I then have a userform where the user can put in values in comboboxes to find the desired data. What I've have been doing so far is opening the database a second time and using the AutoFilter to find the data there, but to improve performance I would like to skip this part and filter directly in the array that already has all the data in it.

Is there any way to filter directly in an array? The array is structured identically to a worksheet (it's pretty much a direct copy from the database) as array(rows,columns) if that helps clarify. Would be delighted for any help!

Regards,
Samuel