Excel 2007 : How can I confirm data has been entered in each column of a row?

[ry8200]

Hello All,

I have an excel workbook that is used as a request template. A user will submit requests to my team using this template and we will process the request based on the information provided in it. Since some users fail to provide all the needed details I would like to add some "data validation" to the worksheet. For each row of the request template I need to confirm that data has been entered into each cell.

Starting in column A row eleven (11) the user would begin entering the information, the last cell that needs to be filled in that row is column I. Column I is a Yes/No drop down box. If column I is yes then the validation would need to also extend to column J otherwise the validation will end at column I. Column K is auto calculated based on values entered in columns E and D. Then columns L through N are auto calculated based on the value provided in column H.

Upon saving the request template, I also need to ensure that values in cells B3, B4, B5 and B6 do not say "Please Select".

There is some data validation based on certain columns:
Column A is =LEN(A11)=11
Column E is =AD_Domain (Which is a drop down list of different values)
Column F is =ISNUMBER(SEARCH("@",F11)) (This is to ensure the requester has entered a valid internet email address)
Column G is =Language (Which is a drop down list of different values)
Column H is =INDIRECT(VLOOKUP($B$5,CountrySA,2,0)) (Which produces a drop down list of different values)
Column I is =Yes_No (Which is a drop down list of Yes or No)
Column J is =ISNUMBER(SEARCH("@",J11)) (This is to ensure the requester has entered a valid internet email address)

Protected formulas
Column K is =IF(OR(E11="Please Select",E11=""),"",CONCATENATE(E11, "_", UPPER(D11)))
Column L is =IF(OR($H11="Please Select",$H11=""),"",IFERROR(VLOOKUP($H11,DefaultUserConfig!$C$5:$F$1048576,2,FALSE),"No Default Group for Regional Country"))
Column M is =IF(OR($H11="Please Select",$H11=""),"",IFERROR(VLOOKUP($H11,DefaultUserConfig!$C$5:$F$1048576,3,FALSE),"No Default Group for Regional Country"))
Column N is =IF(OR($H11="Please Select",$H11=""),"",IFERROR(VLOOKUP($H11,DefaultUserConfig!$C$5:$F$1048576,4,FALSE),"No Default Proxy for Regional Country"))

[dilipandey]

Hi ry8200,

Welcome to the forum.
Please post an sample file. Click on "Go Advanced" while replying and look for paper clip icon to attach the file. Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>