I am working on a workbook, and I know I need a code. I have never used one and I am clueless. I'm hoping someone can help me!!! I know you have helped others. I want to take the information from one workbook and split it into 2 others depending on one column's information. The "master list" has A1-U466, and grows daily. I need all the information in each row to copy over to another workbook based off the information in column C. The information in column C is either "SA" or "CDF". These will have their own Sheets, labeled as such. I'm working with Excel 2010. Please help me, I am at a loss on how to get this done. Thank you in advance!!!!!!