On sheet 6 in columns A and B I enter names of employees and in column C I enter their salary.
On Sheet 1 columns A and B the names are pulled from sheet 6 and the same with salary. Then on sheet 1 in columns D:J I enter the hours they work each day.
What I'm trying to accomplish is when I need to hire or terminate an employee I can add or remove a name from sheet 6 and still keep it alphabetized.
I have the code to alphabetize the names on sheet 6 and this works great, I can add a name at the bottom of my list and when I hit enter the macro actomatically alphabetizes the names.
My problem however, is that when these names are alphabetized on sheet 6 (which in turn keeps them alphabetized on all sheets) if I add a name or remove a name in the middle of a week and the names are alphabetized the hours I have for each person on sheet 1 (D:J) doesn't stay with name.
So, I figure I will just use sheet 6 as employee data only(names and salary) and alphabetize sheet one, that way everything associated with columns A:C will stay with A:C and not columns A:C alphabetize but columns D:J stay.
So what I'd like to do is when I add or remove a name on sheet 6 call my macro to alphabetize sheet 1, sheet 2, sheet 3, sheet 4, and sheet 5.
I hope I explained it okay, it's really hard to explain what I want to do with out you looking at my setup.
Thanks,