I'm working on a project at work whereby staff record important documents that they have returned to customers.
When I became involved with this two staff (now five) used an Excel spreadsheet to record these in, but there were countless formatting errors, entries were in a mixture of date formats and letter case (I hate to write that the staff involved are not very IT literate). In essence it was a mess and management wanted it tidying up, with a 'front end' put into place to ease data entry.
It's fair to say that I'm a bit of noob too with Excel but I have battled through and managed to create a useable form to ease data entry (although with the organisational constraints I've had to work within I fear its now more of a mess than when I started!)
However, I now need a second form whereby the staff can input a day’s date, hit search, details of the documents returned that day appear in the form, they can then input the postal services tracking number into each records 'TrackNum' cell, and then re-save the data.
Leith Ross's solution to someone else’s query at http://www.excelforum.com/excel-prog...-userform.html seems to be what I am looking for, but adapting it for my solution is really stretching my pathetic Excel knowledge.
Can anyone, especially Leith, help please?
Please note that we are in the UK so need UK formatted dates dd-mmm-yyyy.
Attached is a blank copy of my Workbook.
Bookmarks