Seperating multiple choices in list

[Michael]

I am really struggling with this, any help would be
greatly appreciated.

I have a spreadsheet used for placing orders based on
stock and history. The problem I have is that there are a
number of different companies in the spreadsheet although
it is sorted by company. If I order in the order column I
need a macro to identify which company and copy only the
ordered lines to another workbook, then look for the next
company with an order. There could be up to 15 companies
in the spreadsheet with any number ordering. I can have a
seperate list of all the companies for reference if
necessary.

Thanks
Michael