2 Workbooks, a Macro and a little filter!

**AmandaV** · 06-16-2009, 08:55 AM

Hi,

I am far from advanced in excel, but I have been tasked with creating a macro which includes filtering.

1) I have a workbook called Workbook1
2) I need to copy Sheet 3 from Workbook1 cells A1-J5000 into a new workbook called Master.
3) Column D is labelled Status and the two statuses are Enabled and Disabled.
4) I need to copy anything labelled Enabled to a new worksheet in the workbook already created called Enabled and then the same for Disabled. I then need to put it into date order which is column F labelled Date.

I have been trying to work on this all morning, but have found that Excel doesn't like Macros with filters and I don't know the first thing about VBA. Any help anyone can give me would be great. Thank you in advance.

**AmandaV** · 06-16-2009, 09:06 AM

Sorry it's not letting me edit the title. Should be something like Using filters within Macros.

**Phil_V** · 06-16-2009, 11:56 AM

Amanda,

Please see the attached. You will need to unzip it to a folder.
The 'Master.xls' workbook contains the macro, and the workbook1.xls is just some sample data I made up according to your formatting instructions above.
I've put comments in the code so that you can hopefully see what each section is doing, but if you have any comments or questions about it feel free to paste the section of code into this thread, (don't forget the code tags

), and I'll try to explain it more