Hi Lisa

Try this
http://www.rondebruin.nl/copy5.htm

See the workbook example

--
Regards Ron de Bruin
http://www.rondebruin.nl



" wrote in message
...
I have several orders for vendors for various stores and they are all
currently in the same worksheet in a very long line item list. Is there a
macro that can find all the cells that have the same vendor name and export
those into a separate workbook that we can email to that particular vendor?
Thanks in advance for any help anyone can offer!
Lisa