Invoice validation phase 2.zip (75.1 KB)
in file path folder u have files
help me with this also
Pick the Employee name from ‘Line Description’ column-D and filter all the entries starting with the employee name in SalesJournal file.
For each row of employee details, fetch the values from columns – F & G labeled ‘Credit Amnt’ and ‘Qty’ and Open MASTERJOB COST file spreadsheet
Pick the entry matching with the Employee name fetched by filtering from SALES JOURNAL file against the ‘Employee Name’ (column-D) and need to compare with another excel file “Emp Name”