I have been messing with this for all of two days now so a pro I am not. I have a list of assignments that need to be passed ot among around 19 employees. I want to know if it is possible for a novice like myself to create a macro that willadd a results column after the last column, filter by employee, then copy and paste all that data to a new sheet named after that employee, and then have the results column on the main sheet change to whatever the employees add to thier results column. The amount of columns and amount of rows will vary day to day as well.