Service Call Tracking

[Guest]

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.

 

[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

(e-mail address removed)

-----Original Message-----
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?