populate userform with data from pivot table

Hi,

I was wondering if the following is possible and, if it is possible, if someone could point me in the right direction.

I have a large file with multiple userforms. With one of those forms I want to enable the user to go through previous entrees, so that he/she can find the ID number that goes with the previous entree. I cannot use the output table that i use for this, because there are 105 columns in there that the user doesn't need to see. I made a pivot table from the master table, which contains 11 columns. I wanted to use a listbox, but i cannot set the rowsource to this pivot table.

So in short, i'd like to show the entire pivot table that i made in a userform, preferably with search option. Any ideas?

Thank you in advance!

Mathijs

If you are keeping the format of the pivot table relatively fixed (same filters, row headers, column headers and data), then you should be able to assign a name to the data range you want. if the number of rows and columns turn out to be variable, you can make this a named dynamic range.

That works perfectly, thank you!