Pls I have this five excel sheets one is a custodian pension work that contains the names of employee whose pension are remitted that are four other sheets that contains the names of employee for each organisation, the bot is to read the custodian excel file and the pension remittance file for each of the organisation and compile the names of those whose pensions are remitted and the one whose pension are not remitted. Please how do I automate this in Electroneek studio pro
1 Like
Hi @Samcool
To automate this in ElectroNeek Studio Pro, you can follow these steps:
-
Read Excel Files: Use the ‘Read Excel File’ activity to read data from the custodian pension work file and each of the organization’s pension remittance files.
-
Compare Data: Inside your loop, use the ‘If…then’ activity to compare names from the custodian file with each organization’s file.
-
Compile Results: Based on your business logic and the columns in your files, use the ‘Append row to Excel file’ activity to create a new file for the remitted pensions and another file for the non-remitted pensions.
I hope this information helps!
Thank you so much, this is quite helpful