#1
|
|||
|
|||
need help with If statments or VB if possible
What im trying to do is, if sheet2!A1:A5 is updated then id like to put a "*" on sheet1!A1:A5
|
#2
|
|||
|
|||
You could try something like this in the Sheet2's worksheet change event
Code:
Private Sub Worksheet_Change(ByVal Target As Range)Dim c As Range For Each c In Target.Cells Sheets("Sheet1").Cells(c.Row, c.Column).Value = "*" Next cEnd Sub |
Tags |
new text on cell, put * on another sheet, updated cell |
Thread Tools | |
Display Modes | |
|