Excel Macro To Build Master Order Sheets

[DCBUS]

Hello, I need to build a master order list from a master list. I have included two files. The original "Master List" and the output I need it to accomplish "Master List Complete". The original "Master List" will contain a unknown amount of rows when complied. I need the sheet names to be titled with the "Company". Each sheet will only contain the data from the "Master List" company. The final sheets need to be sorted by the "Cost" column sorting highest to lowest.

Thank you JR

Master List

[/URL][/IMG]

Master List Complete

[/URL][/IMG]

 

[mumps]

You are very welcome.