i have Pdf Date excel file and also have Template excel files in subfolders --IBAS\january\template1.xlsx, template2.xlsx.
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.