Smitty, I am working on something similar and would like to ask how to modify your answer for my purpose. I have a workbook with 6 worksheets: Global, AP, LA, EU, NA, NL. I need the macro to look in column H in Global, and depending on the text ( which will be ap, la, eu, na, nl ) copy the entire row to the worksheet of the same name. There are approximately 120 rows in the workbook. Thanks!