View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Lisa@donotspam.com is offline
external usenet poster
 
Posts: 1
Default separate data into mulitple workbooks

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