Forum Discussion
Formula
Hi I'm creating a staff matrix training spreadsheet that shows when their licences & tickets expire & I want to be able to insert new staff members in alphabetical order on sheet 1 & their name carr...
I created a variant, its somewhat dynamic.
I used drop down lists when adding employees to the matrix transaction sheet
and a Power query updates the Staff sheet.
Let me know if you have any questions.
Instructions within the file
What the entry table looks like
What the Staff sheet tab looks like
What the add employee sheet looks like
File attached below: