OK, I'm trying to do a few things with excel I haven't tried before, and wondering if maybe I'm asking too much from it
I'm working with a phone call tracker for inside salesmen, that will track the calls they take so that the outside salespeople can see what is done on a daily basis (my inside department was recently accused by an outside salesman of not doing anything for him)
first of all, I want rows in an excel table to automatically date and time stamp that row when data is started to be entered on it
secondly, I would like the cell for company to reference a table we have, and as I start to type in the customer name (IE: Dupont) it will see that customer name and then fill in the salesman from the table
does anyone know if these things can be done?
Bookmarks