If A1=X cell d1 must be completed before row 2 can be used

  • Thread starter Thread starter Paul07
  • Start date Start date
P

Paul07

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.
 
hi , you can add the data validation for the rest cells
or you can add some VBA code in the selection_change event
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check result if same as other cell on row 1
function to populate a cell where formula is NOT located 6
Using icon sets with relative references 0
check if any values on row 7
Counting Merged Cells 6
Help in counting and summing cells based on multiple conditions 9
will a function do this for me? 1
Averaging values from a list, based on user input 3

Back
Top