Hi,
I need help with below macro. I want to change it so it only inserts number '1' into first 16 rows. next 16 rows i want it to insert number '2' & number '3' for the next 16 rows & so on only where value in Range(D7:D200) is 'uphold' or 'reject'. I want it to continue until there is a value in Range (B7:B200)
Sub Add_box_numbers()
Range("P7:P200").Select
For Each cell In Selection
If cell.Value = "" Then
Else
cell.Value = cell.Value + 1
End If
Next cell
End Sub
Is it possible ? Many thanks for your help in advance.
P.s Basically these are box numbers i am trying to add. ( 16 in one box )
I need help with below macro. I want to change it so it only inserts number '1' into first 16 rows. next 16 rows i want it to insert number '2' & number '3' for the next 16 rows & so on only where value in Range(D7:D200) is 'uphold' or 'reject'. I want it to continue until there is a value in Range (B7:B200)
Sub Add_box_numbers()
Range("P7:P200").Select
For Each cell In Selection
If cell.Value = "" Then
Else
cell.Value = cell.Value + 1
End If
Next cell
End Sub
Is it possible ? Many thanks for your help in advance.
P.s Basically these are box numbers i am trying to add. ( 16 in one box )