Excel Waiting List Help

T

tedkilroy

I could use some help with an Excel Waiting List I am trying to create. My
first column A is labeled Date and I formatted it as date. I have typed in
6/1/07 in A-1; I would like it when I type in in A-2 “6†the 1/07 is filled
in already for me. The reason, this is a log of calls and there may be more
than one entry call for that date. (Lazy typer)

Also need help with column C. If in C-1 I type in Smith as the last name I
would like it to type in for me “_mith†in C-6 if I type in S. Reason, this
would tell me that person already called that day or in the past.

Sounds like it might not work if there are 2 Smiths, but all I have to do is
scroll up to verify. Each person can only be entered once on this Waiting
List.

Any suggestions?
 
T

tedkilroy

Actually that only works if I type in 6/1/07 in A-1 through lets says A-5.
But in A-6 if I type in 6/2/07 and then use cntrl+; in A-7 it fills in with
6/1/07.
 
B

Bill Sharpe

tedkilroy said:
Actually that only works if I type in 6/1/07 in A-1 through lets says A-5.
But in A-6 if I type in 6/2/07 and then use cntrl+; in A-7 it fills in with
6/1/07.


:
Click to expand...
Ctrl + ; enters today's date, not the date in the row above. Why not put
the day, month, and year in separate columns? Then the typist only has
to type in one or two digits. In fact, if this is a waiting list, why do
you even need the month and the year?

Bill
 
Top