create name
suppose u have a data in sheet 1 fro a1:a10
create name->any name ->suppose abcd->select range
now go to data list and give the name of your variable
hope this will work to create list.
if not please let me know.
happy to help
:)
shyam
On Wed, Mar 3, 2010 at 8:42 PM, karthikeyan
wr
HI,
I HAVE 500 PERSONS NAME IN SHEET1.
LIKE:-BOX
BAT
BALL
BLACK
AXE
IN SHEET2 AND CHOOSE CELL A1 WHEN I ENTER FIRST LETTER LIKE "B" CELL
B1
SHOWS LIST OF AVAILABLE NAMES STARTING WITH "B"-STRING.ITS LIKE GOOGLE
SEARCH. ANYBODY HELP ME ABOVE T
