Marco to Split does not work

Hello,

I Have the attached sheet with the name of several manuaturers that are repeating. In that sheet, I also have a macro that consists of splitting th spreadsheet by manufacturer name (Column A) then copy on a separate folder different reports by manufacturer.

But after running the macro, I keep having the error message below. I have not seen anything wrong with the original data on th sheet. Can someone help me figure out what is going on and how to fix it?

Thanks,

Michael

Sorry I meant to say that this macro is supposed to split by the name of Distributors not manufacturer. Thanks!

It looks more like an assignment than a question for help to solve the problem yourself.
What's your budget ?

I am sorry but I don' understand your question. Can you please clarify?

Remove row 1 of Sheet1

Thank you very much. It works. Thanks a lot!

Thank you but how did you find out?

by stepping through the code with F8