hi every one i need help with the code in excel

i have a data base (a.xls)in which i have the

the name age sex Address City Zip

ex
Name Age Sex Address City Zip

a 13 f xyz Wa 12345
b 22 m assa ca 23456
c 34 f etert io 31333


what i want to is in another excel sheet(ex b.xls)
when i enter only the name it should add the rest

ie when i enter the name it should add the age sex address
etc
can any one help me

tx
suresh

Suresh, please don't post to more than group as it will fragment responses. See
the answers in .newusers

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Satish B" wrote in message
...
hi every one i need help with the code in excel

i have a data base (a.xls)in which i have the

the name age sex Address City Zip

ex
Name Age Sex Address City Zip

a 13 f xyz Wa 12345
b 22 m assa ca 23456
c 34 f etert io 31333


what i want to is in another excel sheet(ex b.xls)
when i enter only the name it should add the rest

ie when i enter the name it should add the age sex address
etc
can any one help me

tx
suresh


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004