Contact list issues

  • Thread starter Thread starter =?iso-8859-1?B?QW5kcuk=?=
  • Start date Start date
?

=?iso-8859-1?B?QW5kcuk=?=

Hi all, just a couple questions.
I am trying to make a spreadsheet to keep track of clients
we have using our office.

I have it setup like this.

A B C D etc...
1 ID Date First Last
2
3

the first thing I'd like to do is have the ID field auto
populate if there is information in C. All i need for the
ID field is for it to just ad 1 to the previous #. My 2nd
question is about the date, is there a way to have the
date auto populate with the current date when information
is entered into the first name field? I don't want the
date to keep changing every day, I would just like the
date that the information is entered in on. My last
question is is there a way to have information entered
into a cell always be capitalized?

Thanks.

André
 
Andre
one way
Let's assume that line 1 already has data in it, or has
example data

In cell A2 enter the formula =IF(C2="", "", a1+1)
That gives you your auto incrementing ID field
Then use DATA/FORM to bring up a form. Your users can use
the CTRL-; key combo to enter todays date as a date, and
tab to move between fields.

simple and reasonably effective.

Another way
Build a userform and validate the data as it is passed to
the spreadsheet, i.e. only display boxes for First, Last,
etc, and have the form enter the date and ID. It will
also be possible to UPPER case the data that is passed to
the spreadsheet by converting the values.

Much better results for a little work.

There is at least one other method I can think of, but
these two give you a bit of a choice.

Steve
 
Back
Top