Macro to insert row, sort list and insert sheet with corresponding name, help?
Posted by Brad on June 28, 2001 5:48 AM
I have a workbook that has a sheet for each of 10 employees. There is a tally sheet at the end that sums all the employees hours by job in a matrix. The employees are listed alphabetically down column B (First name in A and Last name in B). I want to make a macro to insert new employees when needed. It needs to make a sheet with the employees last name that is the same as a template sheet "Template". It also needs to add the employee into the matrix and then sort the matrix. I do have an average of the hours at the bottom so I can't just use a whole column sort, it has to be able to tell how many employees I have (column A is blank under the last employee and column B contains the text "Average"). I would also like the sheet with the Last name to be place alphabetically between the other sheets. Any help is greatly appreciated.