If A1=X cell d1 must be completed before row 2 can be used
If the text in cell A1 = Cheque then other cells in row 1 need to be
completed, one of which must be cell D1 which will contain the cheque number before allowing row 2 to be used. |
If A1=X cell d1 must be completed before row 2 can be used
hi , you can add the data validation for the rest cells
or you can add some VBA code in the selection_change event "Paul07" wrote: If the text in cell A1 = Cheque then other cells in row 1 need to be completed, one of which must be cell D1 which will contain the cheque number before allowing row 2 to be used. |
All times are GMT +1. The time now is 06:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com