Macro to Hide Row Once Date is Entered Into a Cell

Hello. This is a three-tiered question. The first, what VBA code do I need to program the Summary for Invoicing tab to hide a row once a date is entered in column a?

The second question: Can I hide an entire tab using VBA code? If so, what code will I need for each tab (that is not the Summary tab) that once 'Y' is typed in column S, the entire tab is hidden?

Third question: Once I copy the Template tab to a new tab and rename it, can I program the Summary Tab to automatically fill in the new data from New tab, row 6, starting with column b to the next available row in Summary tab, also starting in column b?
Macro to Hide Row Once Date is in Cell, for Excel Forum.xlsx

Thank you.

1) This code in the Summary for Invoicing sheet module will hide rows when you add a date to column A.

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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

Thank you so much for these solutions! I love how you even went above and beyond creating that form for me. It is perfect! The only problem was the tab did not hide once I entered the Y in column S.

The original code I provided would only hide the sheet if a capital Y was entered in column S. If you'd endered a lower case y, or Y with a trailing space it wouldn't work.

Attached version with a slight amendment to take care of both of those scenarios.

Please Login or Register  to view this content.

Hopefully that works for you now.

BSB

It did work! Thank you so much! You are a wizard. Lol!!

Very glad I could help.

BSB