Finding data using wildcard
Posted by Thirty on April 05, 2001 9:17 AM
Let say. I have 2 sheets in my workbook
Sheet 1 is to fill in data. while in sheet 2
is like a search engine for find data
In sheet 1. I use A1:C10 to fill data which
is in column A is for names , column B for
identity card and column C for adress.
How can in sheet 2 when I type a* , it will
display all the names starting with a with
their particular details. Let say in sheet 1
there are 3 names starting with the alphabet a,
how can i display it in sheet 2 by typing a*
and show the peoples with a names with their particular
details(identity card and addresses)
Thanks in advance