I have 2 workbooks. (Both workbooks are generally open all the time) Workbook 1 is a list of scale tickets. Column B is the scale ticket number. Column F is "FROM" and Column G is "TO". Workbook 2 has worksheets named after each vendor. If a vendor name appears in either column F or column G in Workbook 1, I would like that entire row to copy to the worksheet with the same vendor name in workbook 2. Also, if this is possible, will it happen automatically or will I have to tell it occasionally to perform this? If I have to tell it to happen, is it possible to just run it on a selection of rows, so that rows that were previously copied are not copied again? I don't know much about Excel and appreciate any help. Even knowing if it is possible would be nice.Thank you.

---------- Post added at 10:36 AM ---------- Previous post was at 10:35 AM ----------

I am using Excel 2010, not 2003.