Need to automate based on set of values and populate

C

CC

I just list out my real excel sheet below for your reference.

In an Excel sheet, First column represent the requirement for report needs.
Then remaining column are questions. Then business user (Business group) will
fill up the remaining columns (from G to O columns) with Values as YES or NO.
The YES or NO values are filled manually by the users.

I have created a sample code for one condition,

Sub TstMcro()

MsgBox Sheet1.Range("G2").Value & Sheet1.Range("H2").Value &
Sheet1.Range("J2").Value & Sheet1.Range("K2").Value & Sheet1.Range("L2").Value

If Sheet1.Range("G2").Value = "YES" And Sheet1.Range("H2").Value = "YES" And
Sheet1.Range("J2").Value = "YES" And Sheet1.Range("K2").Value = "YES" And
Sheet1.Range("L2").Value = "YES" Then

MsgBox "Four yes values"

Sheet1.Range("P2").Value = "ONE"

Else

MsgBox "all values are not yes values"

Sheet1.Range("P2").Value = Null

End If

End Sub



My question is how do i make this work for 30 rows of value for different
combination.

Thanks
 

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

Arrays and scattered cell values or another way? 16
Cell values to an array, then array transpose to another workbook 8
Code does not error but no copy either 4
Value from one sheet paste under same value on other sheet. 7
Copy FROM - TO Object/Block variable not set 6
Insert columns and values programmatically with IF statement 9
Code works but goes into endless loop and crashes 1
Sheet to sheet code Type Mismatch 6

Top