Excel Waiting List Help

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?
 
J

Jordon

tedkilroy said:
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)

How about CTRL+; (semicolon) to auto enter the date?
 
G

Guest

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.


:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top