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.