1) This code in the Summary for Invoicing sheet module will hide rows when you add a date to column A.
2) This code in each of the subsequent sheets module will hide a tab when you enter a Y in column S. At the moment it will hide the sheet if a Y is placed anywhere past row 5 in the sheet, but could be restricted to just one cell if that would work better for you.
3) I've added an icon to the Summary for Invoicing sheet that when clicked will open a simple UserForm. This form will ask for some limited details on new candidates and when you fill them out it will make a copy of the template sheet, name it appropriately and add the details you entered on the form to the relevant fields before setting up formulas on the Summary sheet to link a new row to the new candidate's sheet.
Code for that form is below.
See attached for it all working.
Hopefully it gets you somewhere near the desired results, but let me know if you need anything changing in it.
BSB
Bookmarks