G
Guest
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?
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?