I am busy building an InputForm on a worksheet in order to get control over the integrity of the data in the dataset. I have put in some Input validation in all the cells to control that the cells will not be empty when you save the data to the worksheet. I have included a copy of my project and the validation is in Column I. I have uploaded the mini sheet.
My request for help with the validation is the following starting from the first cell H6:
When you complete the entry in Full Tender Description [Cell H6] TRIM data in Cell and update Add Record (Timestamp) [Cell H32] with the date & time in the =Now()FORMAT(dd MMM yyyy HH:mm)
When you complete entry in Tender No [H7] TRIM data in cell and update Add Record (Timestamp) [Cell H32] with the date & time in the =Now()FORMAT(dd MMM yyyy HH:mm)
Envisaged award date [H20] – default date must be =Now() FORMAT(dd MMM yyyy). Must be automatically be calculated from Tender closing Date [H13] + Offer valid for – DAYS[H19]. Must be calculated as soon as Tender closing Date [H13] has been entered/updated
Compulsory Briefing [Cell H14] – Has a dropdown with Yes/No. Default is NO. If Selection is NO then the value in Briefing Date/Time [H15] must be set to “No Formal Briefing”.
If Compulsory Briefing [Cell H14] – Has a dropdown with Yes/No. If Selection is YES then the value in Briefing Date/Time [H15] must be able to take a DATE in FORMAT (dd MMM yyyy HH:mm).
My request for help with the validation is the following starting from the first cell H6:
When you complete the entry in Full Tender Description [Cell H6] TRIM data in Cell and update Add Record (Timestamp) [Cell H32] with the date & time in the =Now()FORMAT(dd MMM yyyy HH:mm)
When you complete entry in Tender No [H7] TRIM data in cell and update Add Record (Timestamp) [Cell H32] with the date & time in the =Now()FORMAT(dd MMM yyyy HH:mm)
Envisaged award date [H20] – default date must be =Now() FORMAT(dd MMM yyyy). Must be automatically be calculated from Tender closing Date [H13] + Offer valid for – DAYS[H19]. Must be calculated as soon as Tender closing Date [H13] has been entered/updated
Compulsory Briefing [Cell H14] – Has a dropdown with Yes/No. Default is NO. If Selection is NO then the value in Briefing Date/Time [H15] must be set to “No Formal Briefing”.
If Compulsory Briefing [Cell H14] – Has a dropdown with Yes/No. If Selection is YES then the value in Briefing Date/Time [H15] must be able to take a DATE in FORMAT (dd MMM yyyy HH:mm).
Copy of Tenders Database Workbook_08-Sep-21.xlsm | |||
---|---|---|---|
K | |||
137 | |||
InputForm |