2 VBA Excel program Codes
Budget: $10 – $30 USD
We need to 2 codes for excel VBA
1- Create a Code that automatically generates the Transaction ID, the Transaction ID consists of "T"+SubjectID+StudentID+TransactionNo. ("for now use the Subject ID as "MTE21023" , the Student ID will be entered previously in Student ID Column, the default of the Transaction No. should be 01") , the code will CONCATENATE these data together, then it should check all the previous entered Transaction ID's, if for example T+MTE21023+StudentID+01 was entered before then the code should increment 01 ---> 02 and then rechecks until the Transaction ID is unique and should show in the current cell. Also incase the transaction ID was not found before then "T"+MTE21023+StudentID+01 should be shown in the cell. After the Transaction ID is shown in cell we need the Transaction to be copied to the Transactions file as well as "Student ID" "St-Name" "Transfer" "Amount" "Credit". Also output message with the Transaction ID + text that indicates the transaction was copied successfully. (Please not that always there are new transactions in both sheets , in addition transactions will be copied from multiple files to Transactions file).
2- Create a VBA code that Calculates the Credit left for each student. It should check the Payments sheet to look up using the Student ID the total credit that has been added for each student (Note that credit added is updated regularly). Then Checks the attendance sheet for attended classes (Using the Student ID as well) , for either attended value "Attended" or "Recorded" then a credit should be deduced for each, else if "N/A" or "Absent" don't deduce. After the net Credit left is calculated it should show in data sheet corresponding cell to each student. Note that if the Credit in the payment sheet was = "-" then don't calculate credit for this student. (Note we need the Total Added credit and the total deduced credit for each student to show in another sheet to be created). also we need to output message for certain values of credit (we will give the prompt when awarded). Note that we can have new students that weren't in the sheet before , also the credit and the attendance is regularly updated.
Please make sure you can provide them as fast as possible , in addition of fully debugged , error-free codes
1- Create a Code that automatically generates the Transaction ID, the Transaction ID consists of "T"+SubjectID+StudentID+TransactionNo. ("for now use the Subject ID as "MTE21023" , the Student ID will be entered previously in Student ID Column, the default of the Transaction No. should be 01") , the code will CONCATENATE these data together, then it should check all the previous entered Transaction ID's, if for example T+MTE21023+StudentID+01 was entered before then the code should increment 01 ---> 02 and then rechecks until the Transaction ID is unique and should show in the current cell. Also incase the transaction ID was not found before then "T"+MTE21023+StudentID+01 should be shown in the cell. After the Transaction ID is shown in cell we need the Transaction to be copied to the Transactions file as well as "Student ID" "St-Name" "Transfer" "Amount" "Credit". Also output message with the Transaction ID + text that indicates the transaction was copied successfully. (Please not that always there are new transactions in both sheets , in addition transactions will be copied from multiple files to Transactions file).
2- Create a VBA code that Calculates the Credit left for each student. It should check the Payments sheet to look up using the Student ID the total credit that has been added for each student (Note that credit added is updated regularly). Then Checks the attendance sheet for attended classes (Using the Student ID as well) , for either attended value "Attended" or "Recorded" then a credit should be deduced for each, else if "N/A" or "Absent" don't deduce. After the net Credit left is calculated it should show in data sheet corresponding cell to each student. Note that if the Credit in the payment sheet was = "-" then don't calculate credit for this student. (Note we need the Total Added credit and the total deduced credit for each student to show in another sheet to be created). also we need to output message for certain values of credit (we will give the prompt when awarded). Note that we can have new students that weren't in the sheet before , also the credit and the attendance is regularly updated.
Please make sure you can provide them as fast as possible , in addition of fully debugged , error-free codes