To avoid a type mismatch error, change this line:

If Target = Range("A2") Then

To this:

If Target.Address = Range("A2").Address Then



"Mike B" wrote in message
...
Hello, I am trying to figure out a way to make a database and I was hoping
someone could help me with a snag I hit. I am trying to create a database
in
Excel. It will basically have two sheets.

One for all of the information, and the other to act as a sort of search
function. The sheet with all of the information will have several
columns,
including a persons name, clothing size, shoe size, etc. What I want on
the
second sheet it to be able to type the persons name (which will be column
A)
and be able to search the database and show all of the information in the
rest of the columns. (For example, the name in column A2 is Joe and there
are
three other columns. The search would return all of the information in
columns B2, C2 and D2)

I know that there is a way to do this, but my experience in programing
with
Excel is somewhat limited. Is there anyone that can help or at least point
me
in the right direction? Any help would be greatly appreciated. Thank you.