Advanced Excel VBA for our company NOX AB

Closed Posted Aug 28, 2014 Paid on delivery
Closed

The cleaning company "NOX AB" needs Excel VBA implementation in order to track the handling of keys internally and externally (customers and realtors).

The file attached is our current booking schedule that gets filled up with all the bookings for a week. What we need is a Excel file that works as an userform for each booking. Our cleaners and inspectors need to be able to log the handling of the keys internally for each step of the cleaning process. This means the following for EACH booking on a laptop that will be running the excel file 24/7 at our office:

- Logging when a key has been collected from a realtor or customer has handed in the keys to us.

- Logging when a key has been collected and handed in before/after cleaning.

- Logging when a key has been collected and handed in before/after inspection.

- Logging when a key has been returned to office for 2nd cleaning.

- Logging when a key has been returned to either broker, customer or at the office for pick-up.

Besides these functions, the Excel file should also be able to give out automated warnings based on time IF a key for a mission is not returned to broker 4 hours before customer access.

Feel free to ask questions about the project for more details. I will be supervising the whole project through Skype and TeamViewer so those applications are required. It is highly meritorious if you have conducted similar userforms and/or time-alerts in excel (send samples to my inbox).

Best regards,

Anton Terziev

Article Submission Article Writing Copy Typing Data Entry Data Processing

Project ID: #6381641

About the project

8 proposals Remote project Active Oct 4, 2014

8 freelancers are bidding on average $9/hour for this job

DominiqueFranc

Hello! Though I am new writer at freelancer.com so as my enthusiasm to write interesting and mind mesmerizing contents. I don't advocate my self much. My job will be straight forward to please the client. I prefer u - More

$26 USD / hour
(2 Reviews)
4.6
vsprybhanu

Hi, Experienced VBA Expert and VB.Net Programmer. Expertise in Advanced Excel VBA Programming, Data Entry, Data Processing, Excel and VB.Net. Read and understood your project description. I've done similar More

$5 USD / hour
(13 Reviews)
3.4
TypingMachine

Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I have developed many project. Particular, I have rich experience in Excel VBA project. I can provide you the be More

$5 USD / hour
(1 Review)
2.0
omar00bd

A proposal has not yet been provided

$5 USD / hour
(0 Reviews)
0.0
ExcelMacros

We are Excel Expert and have done lots of automation will be glad if we get your job too. If you send completed requirement i believe all this will get complete in 150$ in week.

$16 USD / hour
(0 Reviews)
0.0
satyanarayana82

Expert in vba and excel. Created forms and used access as back end database. Other than vba good in ado, sql which allows to manipulate the data where excel doesn't support.

$2 USD / hour
(0 Reviews)
0.0