How do I make a particular column required in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our NPO is creating a reimbursement chart in Excel. We're trying to make it
so that if employees do not fill in one particular column entitled
"Projects," they will get an error or will be unable to have a final sum
filled in.

Is there any way I can make this particular column required so that if it is
not filled in, the chart will not complete properly?

Thank you in advance for any advice or help!
 
for i = 2 to 30
if cells(i,1) <> "" then
' fill in this row
else
msgbox "You need to fill in " & Cells(i,1).Address
End if
Next

in a formula

=if(A1="","", formula to calculate value)
 

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

How do I make a particular column required in Excel? 2
How do I make a particular column required in Excel? 4
How do I make a particular column required in Excel? 1
Making a particular cell or column required 3
How do I automatically create lists from column topics in a chart 0
Making a column or cell required 1
excel 07 Dynamic copy certain cells if criteria is met onto next s 1
Excel Making a cell Mandatory 9

Back
Top