Hi!

Since my last thread on this topic didn't receive any replies I thought I'd try and simplify the problem a little. What I want to do is basically create a filter for my data, identical to the autofilter function in excel. However, the data must be hidden from the user, and preferably be internally stored in an array rather than in a worksheet. I then want to place the menus from the filter on a userform, so that the user can easily make correct selections before executing the rest of my code.

Is there any way to do this without manually writing performance-demanding on-click macros?

Cheers!