I have a worksheet that I wish to separate into separate worksheets by a persons name. I want to copy a row if it meets a certian criteria, D<>"" and paste it into the new worksheet. I can sort Column C wish will contain the persons name, and for every change in column C it will pull the next persons name and create a worksheet with that name and then loop through and if there is no change in column C and if column D <>"" then I want to copy that row into the worksheet. I kind of see what I want, and know what I want, I am just not familiar enough with VBA to understand how to GET what I want. I know there will be a loop and I feel like the more seasoned excellers out there will be able to get this.

Thanks in advance!