creates a filter and copies to new workbook, want user to select filter

**delboy2405** · 01-23-2012, 01:02 PM

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.

**jaslake** · 01-23-2012, 03:58 PM

Hi delboy2405
Try the code in the attached. Let me know of issues.

PS: Sorry, I forgot to make the Named Range "Products" Dynamic. If you need help with that let me know.

**delboy2405** · 01-23-2012, 05:23 PM

Hi Jaslake, that looks great I must say, pretty much what I was thinking. Do you have any good sites with tutorials on user forms etc as ideally i would like to be able to make that myself.

**jaslake** · 01-23-2012, 08:13 PM

Hi delboy2405

Have to be honest with you, what I know (which is not a lot compared to the talent on this Forum) I've learned by doing and by doing Google searches. I have one book to which I refer not often...John Walkenbach's Excel 2007 Power Programming with VBA.

There is a Thread in this Forum that has many, many references to Resource Materials but I couldn't find it tonight to give you a reference...sorry. Good luck and good hunting.