I'm struggling with the same problem. I have a long list of items that are
grouped by product types, but scattered within the list. This list is
imported to excel from another program that I have no control over, and is
updated from time to time.

What I need is to sort items of different types to different columns on
another worksheet. These columns are then used to populate comboboxes.

Is there a function in excel for this? Also advice on appropriate VBA code
is galdly accepted.

Thanks,

Alerion