I included a workbook example to this post. The data validation needs to be expandable as the table will expand over time. The validation would be in column I "Batch Release Submission Date." When a user places a value [date] in the cell, it will only allow the entry IF the row of the selected cell has entries for all columns A through H and J through N.
Example: I have I6 selected, and I want to put a date in it. According to the table, F6 and M6 do not have anything in their respective cells. An error message would alert the user that the respective row needs to be filled prior to an entry in column I.
I iterate: The table will grow over the course of a year, so the validation needs to grow with it. Is that possible?
Thanks, experts!
Bookmarks