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
![]()
Please Login or Register to view this content.
thanx a lot
Bookmarks