2 VBA Excel program Codes

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

Habilidades: Excel, Visual Basic, Arquitetura de software, PHP, Visual Basic para Apps

Veja mais: send data excel program, vba extract image address web excel, excel program wanted, sample excel vba database program, vba excel program database, excel program clock vba, free money excel program design beam excel, codes sample excel vba applications, excel program handle vba, multiuser vba excel program, excel vba inventory program, excel vba standalone program, excel vba for creative problem solving part 1 coursera, useful vba codes for excel, excel essentials: the complete excel series - level 1, 2 & 3, useful vba codes for excel pdf, vba codes for excel, excel/vba for creative problem solving part 1, excel/vba for creative problem solving, part 1

Acerca do Empregador:
( 7 comentários ) Cairo, Egypt

ID do Projeto: #30870773

Concedido a:

(118 Comentários)

12 freelancers estão ofertando em média $24 nesse trabalho

(216 Comentários)
(19 Comentários)
(120 Comentários)

Hello. How are you? I checked your job description carefully. I am Full-Stack Developer .So I'm very confident in your project and you will satisfy with my perfect result for all requirements as you want. If you hire m Mais

$20 USD in 7 dias
(6 Comentários)

Hello, I have just gone through your requirement which is mentioned in your project (2 VBA Excel program Codes ) and would like to work on your project. I have fully understand all your requirements which is mentioned Mais

$10 USD em 1 dia
(3 Comentários)

Hello, I'm an Engineer .I have many Experiences in microsoft excel,python ,C# ,VB , specially in windows application

$30 USD in 2 dias
(7 Comentários)

Hello! Do you need ribbon buttons to run these macros and should they be available in a specific workbook only? Or do you need an add-in? Anyway, I'll be happy to help you as this work fits my developer skills. My VBA Mais

$10 USD em 1 dia
(4 Comentários)

Hello there. This is omar. I wish you are in a good mode. The project can be done with python, I can send the code for you if you want. Contact with me to talk about the project.

$30 USD in 7 dias
(2 Comentários)

I can do the project for free as I need positive reviews for my profile. I have a weekend and I can complete this by tomorrow. I am expert in Visual basic so if you can tell me the complete details, I can help you with Mais

$10 USD em 1 dia
(0 Comentários)

Hello Sir/ man I have checked the project details. I'm expert in data entry [login to view URL] me so I can make few samples before you award the [login to view URL] forward to work with you. I have good communication as well as col Mais

$20 USD in 3 dias
(0 Comentários)

I will. . .

$20 USD in 7 dias
(0 Comentários)