Hi there,

i have problem and i need help with it, pls.
I have huge table and i need make search form where i can set up what i want
sarch, chose criteria for searching and then i need if it will find
something, make a list with found rows where data, for what i have been
searching are placed and when i will chose some from them it will load data
into form.

small example:

table:

name surname date age
franky longfoot 1.11.1111 19
franko shortfoot 2.11.1111 19
franko shortfoot 2.11.1111 18
franko shortfoot 3.11.1111 17
franko shortfoot 2.11.1111 19


and i need make form where will be forexample textboxes where i`ll be able
fill information about name or surname or date or age or 2of them and i
will press search button and it will search whole table find all rows where
are mentioned my searching criterias and results will be displayed in
listbox. Then when i will choose some founds from listbox then it will open
formular where will be displayed all data from row which meeted my searching
criterias.

can anyone help me with search form?? thx.

Hi Frank
How about a filter
read about at Debra Dalgleish's http://www.contextures.com/tiptech.html
or a video tutorial (really cool)
by Michael Alexander at http://www.datapigtechnologies.com/ExcelMain.htm

Note when a filter is in effect you will see the arrows of the filter and row numbers
turn blue. To remove all filtering
show all but keep filters intact: click on arrow choose "(All)"
same but for all columns: Data, Filter, Show All
to remove filter: Data, Filter, (uncheck) autofilter

additional Tutorials can be found at
http://www.mvps.org/dmcritchie/excel....htm#tutorials

some additional comments:
a Filtered Spreadsheet treats what you see after filtering as the content.
http://www.mvps.org/dmcritchie/excel...a.htm#filtered
which can be useful if printing labels such as in using Mail Merge
http://www.mvps.org/dmcritchie/excel/mailmerge.htm

The above is how I read your question you might also
check VLOOKUP Worksheet Function
http://www.mvps.org/dmcritchie/excel/vlookup.htm
and at the previously mentioned sites.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"frankosun" wrote in message ...
Hi there,

i have problem and i need help with it, pls.
I have huge table and i need make search form where i can set up what i want
sarch, chose criteria for searching and then i need if it will find
something, make a list with found rows where data, for what i have been
searching are placed and when i will chose some from them it will load data
into form.

small example:

table:

name surname date age
franky longfoot 1.11.1111 19
franko shortfoot 2.11.1111 19
franko shortfoot 2.11.1111 18
franko shortfoot 3.11.1111 17
franko shortfoot 2.11.1111 19


and i need make form where will be forexample textboxes where i`ll be able
fill information about name or surname or date or age or 2of them and i
will press search button and it will search whole table find all rows where
are mentioned my searching criterias and results will be displayed in
listbox. Then when i will choose some founds from listbox then it will open
formular where will be displayed all data from row which meeted my searching
criterias.

can anyone help me with search form?? thx.