Compare PLANT CODE in Pdfdata .xlsx and Template.xlsx and filter Data

hi,
i have Pdf Date excel file and also have Template excel files in subfolders --IBAS\january\template1.xlsx, template2.xlsx.

condition is–
1.Plant Code match – from pdfdata to template.xlsx
2,Date Match----(Bot Date in pdfdata and Date in template)
3. if both match then copy total row amount from pdfdata.xlsx to Template.xlsx .

I have marked RED Plant Code.in excel files(Key point)

how to do that ? can any one help.
inv_plantcode.zip (52.8 KB) below.

Hi @Anand_Designer ,

Please see attached working solution. inv_plantcode.zip (38.6 KB)

@GreenTea but its getting mismatch data like… 217.86 is coming 2 times
pdfdata.xlsx

IBAS\january\template_2.xlsx",

Hi @Anand_Designer ,

Sorry, here’s the updated one. inv_plantcode.zip (38.8 KB)

Thank You @GreenTea

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.