Hello,
I have to make a spreadsheet to track credit solicitation. In column B I have a list of my employees (currently entered alphabetically manually). the next columns (D-O) i enter the number of credits opened for each employee, each month. This is totaled into column Q for a year total.
The employees fall into 3 seperate catagories :fulltime, parttime, and D status. I have these employees seperated right now by a title row which also has their monthly goals.
The situation is that i know enough about excel that i can add an employee, and use the 'Data' > 'sort' toolbar to do a quick fix, or even just insert the row in the proper place, but my boss is a computer iliterate person. I will be deploying soon and hope to have this and other data sheets automated for her so that she just updates a few values and it completes all functions for her. So as she will hire people while im gone, and as she wont be able to figure out how to put them in the proper spot, im looking for a way to have excel automatically alphabetize the employees with in each status, AND keep their row integrity. If you know how to help me, then please let me know.
If you need a visual, let me know
email address removed by Moderator - refer to points 18 & 19 of the Posting Rules
I have to make a spreadsheet to track credit solicitation. In column B I have a list of my employees (currently entered alphabetically manually). the next columns (D-O) i enter the number of credits opened for each employee, each month. This is totaled into column Q for a year total.
The employees fall into 3 seperate catagories :fulltime, parttime, and D status. I have these employees seperated right now by a title row which also has their monthly goals.
The situation is that i know enough about excel that i can add an employee, and use the 'Data' > 'sort' toolbar to do a quick fix, or even just insert the row in the proper place, but my boss is a computer iliterate person. I will be deploying soon and hope to have this and other data sheets automated for her so that she just updates a few values and it completes all functions for her. So as she will hire people while im gone, and as she wont be able to figure out how to put them in the proper spot, im looking for a way to have excel automatically alphabetize the employees with in each status, AND keep their row integrity. If you know how to help me, then please let me know.
If you need a visual, let me know
email address removed by Moderator - refer to points 18 & 19 of the Posting Rules
Last edited by a moderator:
