Mumps1,
So, you think if I used some helper cells to split the first and last name into separate cells I could simply run with what I have so far? Just define FirstnameLP as the value of the first name helper cell and the LastnameLP as the last name helper cell?
If so, that would look like firstnameLP = range(helpercell).value?
I am aware of middle names and initials however for the purpose of what I am trying to accomplish, the user has to use only first and last names as a rule.
Tim
If you could post a copy of your file (de-sensitize if necessary) it would be easier to help. Include a detailed explanation of what you want to do using a few examples from your data and referring to specific cells, rows and columns.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Mumps1,
See the attached spreadsheet.
We could use columns AH and AI for Last and First Names.
Tim
OK. I had a look at your file. Can you now explain step-by-step exactly what you want to do using a few examples. Also could you upload a version of your file that includes the "Save", "Insert Row" and "Employee_Names" macros. We have to make sure that any new macro doesn't interfere with the existing ones.
Mumps1,
The user will run macro,
the user will enter the first and last name of the new employee into the input box
the macro will look in column "b" to see where the last name of the new employee will fit alphabetically.
the macro will insert a new row (copying all the formulas) and enter the employees name in the column "b" of the new row.
just that easy.... so I thought!
Thanks,
Tim
Have a look at the attached file. You will notice that there are 2 empty rows (rows 19 and 20). Don't delete either of these 2 rows. They are necessary to adjust the formulas correctly. Click the "Add Employee" button at the top. The macro will do the following:
-Prompt you to enter an employee name ... First Name - Last Name
-Prompt you to enter an Employee Number
-Enter that data into the appropriate columns (including AH and AI)
-Copy and adjust the necessary formulas
-Place the names in alphabetical order
-Copy the names to the "Employee" sheet
-Create a new sheet for the newly added employee.
Please let me know how this works out for you
Last edited by Mumps1; 02-15-2018 at 02:25 PM.
Mumps!,
Can you upload the file? I tried to paste your code into my workbook and it didn't work. Not sure if you filled names in the AH and AI columns or not.
Thanks.
Tim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
TimlmiT 
Register To Reply
Bookmarks