I am creating a sheet that will add a new team member and assign certain job taskings. Column AD has a numerical value in it that is based off of certain aspects of the new member (job title, department, etc), and I currently have the list sorted based off of that column from lowest number to highest. I have created a userform that makes generating the info for the new member streamlined, and I have a variable in the coding that is going to be that new member's value in column AD. I am looking for the vba that will find the last instance of that value in the list and insert a row just below it, or insert a row at the appropriate spot in the list to keep the numbers sorted from lowest to highest (both those are the same thing, just worded different to help with clarification and possibly simplicity in the code). Any help would be greatly appreciated!
P.s. I am working on a government computer, so I am posting this thread on my cellphone. I will not be able to upload a copy of my sheet, and if any of my code is needed it will be as decent of a picture as my phone can take of a monitor
P.s. I am working on a government computer, so I am posting this thread on my cellphone. I will not be able to upload a copy of my sheet, and if any of my code is needed it will be as decent of a picture as my phone can take of a monitor
