I've got a master list with 100's of items. I have four columns of
information for each item. (Description, supplier, item number, cost). I
want to generate a list on a seperate page by supplier. For example, every
item that is made by ABC company is put on list A (seperate worksheet), every
item made by XYZ company is put on list B (seperate worksheet) and so on. Is
there a macro or formula that I can use for this?