Hi,
I'm trying to create a "dynamic" db. Db is located in sheet1. Into sheet2, which has the same headers as sheet1, new monthly data will be thrown. Sheet1 needs to pull only entries which aren't already in db, hence no duplication.
Hope I've managed to explain myself 

Sub l_feed()
With Worksheets("l_feed")
Dim rng As Range, r As Range
Set rng = .Range("a1:a" & .UsedRange.Rows.Count)
For Each r In rng
if r.Value 'here r.value should check if it's not already in a certain range in the dbsheet... 
Next r
End With
End Sub