Hi,
I have a excel workbook with one sheet used for data entry
and other sheet contains master database from where i would be extracting
account name while making data entry in first sheet.
What i want is
when i try to write a account name starting with 'A' i want to populate all
the account names from other sheet starting with 'A' to be populated
while data entry.
a sample example can be considered as below
sheet a
Date :
Acc Name : (When i press 'A' here Amrish,Ashok Should be shown in drop
down list)
City :
phone no :

sheet b
Amrish
bhunesh
ashok
rajesh
mital
parmesh


Thanks in advan

Regards
Pavan