Hi there
I have a main data sheet users are not filling in, so what I am trying to look at as a solution is on the "Brief" tab the use MUST enter data in cells D16 and D17 (D17 being a Dropdown only) before moving onto filling data out in the other tabs on the worksheet. Ideally a error box would flash up and say Please enter "Requested By" (D16) and Source (D17).
I have a main data sheet users are not filling in, so what I am trying to look at as a solution is on the "Brief" tab the use MUST enter data in cells D16 and D17 (D17 being a Dropdown only) before moving onto filling data out in the other tabs on the worksheet. Ideally a error box would flash up and say Please enter "Requested By" (D16) and Source (D17).