Macro to Calculate Column Cells based on evaluating other cells in same Row

[Eldorren]

Ok guys, I feel like this should be pretty simple. I have a column that I want to evaluate automatically to "True" or "False" as data is entered in the other columns on each row.

Column 2,3,6,7,8,9 all data validate to "Yes" or "No"
Column 3 is a user's initials "i.e. BR"
Column 4 is a user's Last Name "Johnson"

I want each cell in Column 10 to evaluate to "Complete" or "Incomplete" i.e. True or False

The Criteria for True are as follows:

1) All the cells in the same row are populated with data
2) Column 2,3,6,7,8,9 all must be "Yes"

Otherwise the Column 10 cell on the same row as the data must evaluate to "Incomplete" or "False"

Can anyone help me out with the code on this one? I'm pretty new, but I'm trying to accomplish this in the Private Sub Worksheet_Calculate(ByVal Target As Excel.Range).

Thanks in advance. It's a pretty simple spreadsheet and I feel like this should be a pretty easy macro but I'm new to this. Thanks! -El

[smuzoen]

Welcome to Excel Forum. What you describe sounds straight forward however when submitting questions it is often useful to upload a sample workbook containing no sensitive information as it is much easier to formulate a solution if we can see how your data is set out. To upload a sample workbook select Go Advanced, Manage Attachments and then upload the sample workbook. Make sure it contains no private/sensitive information. To test the solution the person helping you may have to recreate the workbook which takes time. You are more likely to get help if you provide a sample workbook. In the sample workbook show how the data appears and how it should appear after code runs - be very specific explaining your logic.