separate data into mulitple workbooks

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Merge Multiple workbook sheets into one workbook 0
correlating and summing data from multiple spreadsheets 1
Order form design 3
In WORKDAY function, how to exclude multiple/variable holiday rang 4
How to extract email addresses from 1 worksheet to another workbook 11
VB Code Required 3
Excel Workbook, Data Selection by Date 8

Top