hi, everyone
i have a workbook with three sheets with the names ("TO."), ("ENTRY"),("TOTAL."),
I Will start from here, I will enter data here. Sheet("ENTRY").Range("c10:c300"), and i want to add data to sheets("TO.") and ("TOTAL.") at a time
now
I want, IF I add A DATA IN SHEET("ENTRY").RANGE("C10:C300) Then the unique data add TO both Name Range."Names" and Names2.
for example
if I add data 'sid' in c10 then
it look first in range("names"), if 'sid' avalable then do nothing, then look in second range("names2") if 'sid' available then do nothing,
if not available in range("names") then add 'sid'
if not available in range("names2") then add 'sid'
if available in range("names2") and not available not in range("names") then
only add to range("names").
Bookmarks