THe spreadsheet that I inherited here is a training matrix where the employees are listed at the top and the procedures that they are to be trained on are listed in rows. The problem is is that there are multiple rows with the same procedure listed several times... I want to simplify it and only have 1 procedure listed one time. The reason why they are listed multiple times is that some procedures are used in multiple departments (and thus listed multiple times on the spreadsheet.) an example would be Procedure QA-003 GF... is used in both Shipping and Production. What I am aiming to do is remove the department headers (*as shown in rows 6 and 17) and list all the procedures one time, and then when the appropiate button is clicked, (say, for shipping) the procedures associated with shipping will be highlighted yellow. (and I would need another button to 'clear' the highlighted rows, or maybe when the button is selected again it would clear the formatting... not sure how that would work and what would be the easiest way to accomplish this.) Hope all that makes sense and I didnt confuse you even more... lol THANK YOU!
Yea, what I did was just cut alot of the content out for the purpose of posting it here... The rows that would ultimately be highlighted would each have an "X" in the smaller(narrower) cell side in the column that includes their name.
Here is what I am thinking... this is after I have eliminated the duplicate procedures from all the rows... this would be for the Production employees (upon clicking on the Production button
No, I already have the script for that part completed and it works great… What ive hidden from the above screen shots is a column that shows the date the procedure was either created, or the latest modified date if it has been edited. Beside each of the cells that contain an “X”, is a cell that contains a date that each employee was trained for that procedure. I have the cell conditionally formatted so that if the training date is < the procedure creation/edited date, then the cell will turn red. The button I have that says Show/Hide Dates toggles between hiding every-other-cell to show that actual date of when the employee signed off on the training and show just the “X” (so its not as “busy” looking with all the dates showing.)
Here is the actual spreadsheet i am working on showing the X's representing training has been competed, and RED indicating that the procedure has been edited since the training was completed and thus needs to be trained again. Thanks again!
I do not see any thing in these images that would tell me what procedures John Doe needs to be trained on.
Here is what the existing code executes when you hit the shippng button. It shows only employees that are dedicated as shipping (I have a hidden row right below the names in row 1 that specifies what deparetment the employee works in. Shipping is "S". So when the script is ran, it shows only employees with S in row 2 and hides all the others. )
Showing Shipping only: (the procedures (rows) that would be highlighted would only be for shipping specific procedures.)