Macros to create new excel files based on criteria

[fsuguy92]

Hey guys, I have an excel file that I need to create 4 separate files from. In column A I have either "Clean" or "Not Clean" and in column B I have either "NFL", "MLS", or "REMOVE".

What I need is a macro that will create 4 files : Clean & NFL, Not Clean & NFL, Clean & MLS, Not Clean & MLS. I only need it to export columns B:CL and it can ignore anything that has "REMOVE" in column B.

Not sure how difficult this is or if it's even possible but it would be a HUGE help! I'm in the process of learning VBA but this is a little above and beyond my capabilities at the moment. Thank you!!

 

[fsuguy92]

Not without finding out why you are getting the error.

It appears that it worked now, but it only exported one sheet with just 4 columns on it.

 

[Fluff]

Is your data still in the original format?
Also do you have a header for all columns & do you have any blank rows in the data?