Hello,

I have a file where I need to split data in specific columns into separate workbooks so I can give the file to separate individuals. For example, Column A has 3 options, Partner, Sales, Career. So i need to split the data for Partner into a separate workbook. In addition, I need a separate file for Sales and again a separate 3rd file for Career. After that, in column B, I have different categories that I also need to split off into separate workbooks also. For example, If column A says Partner and column B says Call Center then I need a separate file which has all the data for Partner and Call Center. Does anyone know any VBA code that will helpme with this? Right now I am splitting this up manually and it is very, very tedious. Any assistance would be appreciated.