I've got a workbook with around 3000 lines of data, i'ver created a macro that filters under product list and then copies the the data to a new workbook.
Macro that i have does that ok, what i'm trying to now do is to allow the user to select the filter somehow ie. userform and then select products(s) that they wish to be including in the new workbook.
Not sure what the best way to do this is? any advise appreciated?
Current code below, i've also attached a santised workbook
Please Login or Register to view this content.
Bookmarks