jeudi 12 avril 2018

If a cell in column A is not blank then column B equals and column C equals

I want to fill several columns with data if the cell in column B is blank I have managed to do this for one column but am struggling to get it to run for more than one column… So if B is not blank, then complete column K with Customer, complete column P with Allow and complete column Q with Normal (haven’t done as haven’t got P to work yet!)

For Each Cel In Range("B18:B90000")
    If Cel.Value <> "" _
    Then Cel.Offset(0, 9).Value = "Customer"
    'Cel.Offset(0, 5).Value = "Allow"
Next

This helped me to do it for one column: VBA - If a cell in column A is not blank the column B equals This helped me to perform 2 actions but its not working https://www.mrexcel.com/forum/excel-questions/524212-vba-if-statements-can-you-have-multiple-actions-then-area.html If anyone can help, it would be massively appreciated Thanks!

Aucun commentaire:

Enregistrer un commentaire