Hi All
I have a bank statement in PDF and can download in CSV from my bank. Parents pay their child fees into the bank account. I have a workbook in excel from Grade 1 to Grade 5 (different worksheet for each grade). The information in the worksheet are : Name and Surname, Months of the year, Fees, Sports fees,Notes, etc. I enter manually child fees for each into the Workbook in excel by reading the bank statement. This is time consuming and want to be efficient.
Is there a way of autopopulating my excel workbook by extracting the fees data for each student from the bank statement? I was thinking of a macro or something. Any help with this greatly appreciated.
James Mckoy
I have a bank statement in PDF and can download in CSV from my bank. Parents pay their child fees into the bank account. I have a workbook in excel from Grade 1 to Grade 5 (different worksheet for each grade). The information in the worksheet are : Name and Surname, Months of the year, Fees, Sports fees,Notes, etc. I enter manually child fees for each into the Workbook in excel by reading the bank statement. This is time consuming and want to be efficient.
Is there a way of autopopulating my excel workbook by extracting the fees data for each student from the bank statement? I was thinking of a macro or something. Any help with this greatly appreciated.
James Mckoy
