Help for creating a VBA code to enter data into dump file from userform. US$30

Re: Help for creating a VBA code to enter data into dump file from userform. US$15

Have you paid the 10% to Ozgrid as per Hire Help forum rules?

Re: Help for creating a VBA code to enter data into dump file from userform. US$15

I am prepared to take on your development as per your PM and at the total cost of $30.
PLEASE PAY (via PayPal) 10% of the total cost to paypal@ozgrid.com - i.e. pay $3.00 to Ozgrid via PayPal - the remaining $27.00 can be paid to me on completion of the project. I will PM you my PayPal email address when the code is completed. Please post into this thread (not via PM) confirmation that the 10% has been paid to Ozgrid. I will then post some questions I need to have clarified.

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

Just a few things - does EVERY field in the form have to be completed before the user can hit the Add button - that is they cannot leave any of the fields in the form blank?
You just want the user to type in their Employee ID and Employee Name (no drop downs)?
The quantities the user can enter - what are valid ranges/entries - can they enter decimals e.g. 3.5 or do they have to be whole numbers? Is zero (0) a valid entry for quantity?

When the user hits the Add button do you want the form to close and the Dump worksheet to be visible or when they hit the Add button does the form reset and the user keeps entering information until they finally hit the Close button after which the Dump worksheet becomes visible?

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

All of that is fine - only one question:

Quote

Add/Edit: On the same day if I want to edit details of particular employee I just will add Concept, Employee ID, remaining details (entered on the same day earlier) will appear into the userform so that I can edit them. After editing them hitting ADD/edit will update the details into the dump file.

What if there are more than 1 entry for Concept, Employee ID on the same day or will there ONLY EVER be ONE entry for Concept + Employee ID on a single day?

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

I have finished your workbook. I will PM you my Paypal address. Once payment is received I will upload the workbook.
Just a note - with the Add/Edit button - the worksheet you designed records the time difference not the actual times (Start/End times). To repopulate the form with the Start and End time requires another worksheet (quickest solution) - this essentially duplicates the data to be able to retrieve the Start and End Times as well. This would certainly be better as a database application or redesigning the Dump worksheet with hidden columns. However despite the duplication of data all the required functionality is implemented as you requested.
NOTE: If you manually delete any data from the Dump sheet it will need to be deleted from the TimeSheet worksheet as well to synchronise the data retrieval. The password to protect the sheet is in the code - you will need this password to un-protect the sheets. I have highlighted the password in the code for you. If you are unable to find the worksheet password to unprotect it then let me know and I will PM it to you.

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

Payment received thank you. Attached is your workbook.

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

I can fix No 1.
2. You never asked for 24 hour time - it was set up as 12 hour time - you should have asked for this in your specifications. I am not going to recode the workbook for that change as it was not part of your specifications
For 3 if you enter the Concept and employee ID then you hit the Add/Edit button and the form will populate with data if there is an entry in the worksheet. Just select a Concept and add the Employee ID and hit Add/Edit and the workbook will populate. That is the functionality you listed under the Add/Edit button in your post above.

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

Attached is the fix as per 1 - Start Time cannot be greater than or equal to End time

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

I have not done much testing however you can experiment with this workbook - it uses 24 hour time.

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

I have fixed the first one already - it has been uploaded. The last post I made there is also a workbook that uses 24 hour time which you can try.
I will take a look at your other change.

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

This version will auto-populate the form if a match is found for concept and employee id on the current date. This version also uses 24 hour time.