Hi Experts
Need some help with VBA
I have a worksheet, that has a lot of rows of work done during the day. Shows the job number (Prod.Ord), Date, and times worked and so on
Created a test file and put in some dummy data with a command button to link to a userform and created a User Form and I need help with that
The user clicks on the command button to open the form
Cap1.png
In the userform the user will enter the job number and clicks Search
Cap2.png
What I need is a VBA then searches the Daily Production Report worksheet for all the entries for that number and displays the data from Column C, D, E, F, G & H in the Listbox and at the bottom the sum of the total time of those rows
Example below
Cap3.png
I have searched and have been unable to find a solution, or I should say my lack of experience using VBA I havent been able to use anything to suit my needs
Please any help would be much appreciated
Thanks
Rahul
Bookmarks