Hi all,
I have a few problems with creating a booking in and out job system let me explain the intended use before i explain the problems:
The idea is that you will be able to book a job onto the excel sheet using a "book in" button this button will take you to a form to fill in then add your job to the list (with a time stamp)
then the same thing for booking out but when booking out you click the "book out" button and search for your job using a user form then press complete and your job will be deleted and moved to another sheet called completed jobs.
Current issues i am facing are:
When booking in the only thing that transfers from the form to the job list (sheet2) is the timestamp nothing else will transfer.
When booking out the search button wont delete the correct row it will only delete from sheet 1 and not sheet 2.
also the titles currently do not tie up as i have used a macro for the booking out from a different form i plan to tidy these up when its all working.
Please help!!
Booking System to upload.xls
Bookmarks