hi, everyone
i have three worksheets on my workbook
1 = "TO."
2 = "ENTRY"
3 = "TOTAL"
I add data sheets("entry").range("c10:c300"). so when i add data here then automatically add same but unique to sheets("to.").range("b4:b100") and sheets("total").range("c4"c100")
for example
i add "haroon" in range sheets("entry").range("c10:c300")
then "haroon" auto add to sheets("to.") and sheets("total") in range
if "haroon" already added in sheets("to.") and sheets("total") then ignore it
I Think this will done with worksheet_change event
![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.count > 1 Then Exit Sub If Target = "" Then Exit Sub If Not Intersect(Target, Range("C10:C500")) Is Nothing Then and code here.... End Sub
thanx a lot
Bookmarks