Seeking an expert for an Excel Automation Task
Budget: $30 – $250 AUD
I am looking for a freelancer to help me automate a process in Excel. Any technology can be used but C# is preferred. The task involves writing a code to import data from sample.csv to the Target.xlsm I provided without altering the existing macros in the Target.xlsm. The spreadsheet after automated importing the sample.csv should be the same with AfterImport.xlsm. Finally, I required the source code custom tool.
The data in sample.csv contains applicants' information and can be outlined as follows:
1. Applicant Name
2. Number of Employers
3. Marital Status
4. Dependents
Additionally, it has income related data that can be filled under Applicant annual income section:
1. Employer Basis
2. Confirmation of Base Income
3. Income Verification Type
4. Year-to-Date (YTD) Income Amount
5. Pay Cycle
6. Monthly Base Pay (for multiple payslips)
7. Total Monthly Gross Pay (for multiple payslips)
Lastly, it also has specific loan-related data that needs to be imported under Commitments in New lending section:
1. Loan Type
2. New Loan Amount
Applicants are required to have a strong understanding of Excel automation process and the ability to finish the tasks within required time frame.
The data in sample.csv contains applicants' information and can be outlined as follows:
1. Applicant Name
2. Number of Employers
3. Marital Status
4. Dependents
Additionally, it has income related data that can be filled under Applicant annual income section:
1. Employer Basis
2. Confirmation of Base Income
3. Income Verification Type
4. Year-to-Date (YTD) Income Amount
5. Pay Cycle
6. Monthly Base Pay (for multiple payslips)
7. Total Monthly Gross Pay (for multiple payslips)
Lastly, it also has specific loan-related data that needs to be imported under Commitments in New lending section:
1. Loan Type
2. New Loan Amount
Applicants are required to have a strong understanding of Excel automation process and the ability to finish the tasks within required time frame.