lundi 20 avril 2015

I need a macro that will check new entries if it is already existing or it is within the range of an existing entry

I have 2 files with name NewEntries.CSV and Existing.CSV

Header A1(Company Code), B1(PurchaseOrg),C1(TransactionType),D1(CommodityCode),E1(MinTC),F1(MaxTC)

how will I implement this condition to check the New Entries and copy same or within the range entries in a new file or sheet.

IF [NewEntries(A1,B1,C1,D1) = Existing(A1,B1,C1,D1:A*,B*,C*,D*)] & [NewEntries(E1)>= Existing(E*) OR NewEntries(F1)<= Existing(F*)]

Aucun commentaire:

Enregistrer un commentaire