Hi all,
I've set up a simple button to change a cell value from another cell,
Code is
Now I only want to change G6 if it matches a a set criteria, in this case "No" if it it then any other text then don't change the value.
Once this is working I then want to use the range G6:G25 to do the same
Any ideas?
Many thanks
I've set up a simple button to change a cell value from another cell,
Code is
VBA Code:
Private Sub CommandButton1_Click()
Sheets("Sheet1").Range("G6").Value = Sheets("Sheet2").Range("E5").Value
End Sub
Now I only want to change G6 if it matches a a set criteria, in this case "No" if it it then any other text then don't change the value.
Once this is working I then want to use the range G6:G25 to do the same
Any ideas?
Many thanks