VBA Filter, Copy, Paste onto New Worksheet

Hi,

Very first post, thought I would give it a try.
Have spent hours upon hours trying to figure out a solution.

I am working for a company which does Risk Management.
I need to filter my excel file (Risks).
Then need to filter by the "Owner" within the already filtered Excel File.
The "Risk" criteria is in column "B" and the "Owner" criteria is in column "E".

So the macro should copy and paste the filtered results onto a New Worksheet (and saved within a folder).
I would want the new Excel file to have the same formatting, column width, etc

I need to have each "Owner" to have their own excel file for their "Risks" and the name of the Excel file should be the Owner name.
NOTE: For some "Risks", the "Owner" is blank.
I have created a macro already which does what I want until this point.
Any help would be reallllllly appreciated.

Here it is:

Please Login or Register  to view this content.

Hi

Welcome forum.
Please read rules
http://www.excelforum.com/forum-rule...rum-rules.html

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

Post your workbook model.