Service Call Tracking

A

akita969

I work for a service company that is driven by dispatched job numbers. I have created a "whiteboard" in Excel that I update daily, but it is very squished since I have 10 technicians that I track open jobs for. Is there a template out there that could help?
The basic format of my whiteboard is:

Date Dispatched Job # Tech Location/Notes

Thanks.
 
M

Mark E. Philpot

It is hard to answer such a question here. Could you send
a sample sheet to me and I could devise a userform. it
might be easier with textboxes or comboboxes or listboxes
that have all your ranges on a form. The textboxes will
allow you to add entries and an update button will add
them to the respective cells.
See
http://au.geocities.com/excelmarksway for some samples
(Basically designed for excel95 ver7.0, and 97.

or http://www.geocities.com/excelmarksway (although not
too much here as I am still updating to Excel2000
compatibility...

You can send dummy info if you do not want me to see the
good stuff.

regards

Mark

[email protected]
-----Original Message-----
I work for a service company that is driven by dispatched
Click to expand...
job numbers. I have created a "whiteboard" in Excel that I
update daily, but it is very squished since I have 10
technicians that I track open jobs for. Is there a
template out there that could help?
 
Top