I have a userform containing a listbox. In this listbox, theres data imported from a column ("vendor list") in a big spreadsheet.
What i need to do is to give the user the capability to filter the big spreadsheet by selecting lines in the listbox.
The listbox has to act like a filter for the column "vendor list". By filtering that column the user will see the rows corresponding to his selection n the big spreadsheet.
Can anybody help me with this. I assume its a small vba code.
Thanks to the Gurus