hello
I try making macro by vba , what I'm trying link and add datavaldition in sheet2 in COL B,C,D based what it's existed in sheet1 as you see in sheet1 I add data continously and it will be repeated some data the differences in the dates then when bring the data in sheet2 should not be duplicated and not blanks the fill in data validations depends on only what are filled in sheet 1 in COL B,C ,D without duplicated and without blanks and it should automatically show new data in datavalidations in sheet2 when add new data in sheet1 so the data validations takes the data based what enter in sheet1
finally after link them when select the item from col B in sheet2 then would be depends on each other of them COL C,D as are existed in sheet1
Sub dat()
Dim ws, ws1 As Worksheet
Dim range1 As Range, rng As Range
'change Sheet1 to suit
Set ws = ThisWorkbook.Worksheets("Sheet1")
Set range1 = ws.Range("b2:b6,c2:c6,d2:d6")
Set ws1 = ThisWorkbook.Worksheets("Sheet2")
Set rng = ws.Range("b2:b6,c2:c6,d2:d6")
With rng.Validation
.Delete 'delete previous validation
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
Formula1:="='" & ws.Name & "'!" & range1.Address
End With
End Sub