Hi,

I want create new rows with data on the basis data base
(in another sheets).

For example:

In sheets(2) are following records:
Name1 Name2 X Name3 (heading)
AAA TT34 1 OIUY
AAA TTRW 0 PRTU
BBB YTWY 1 RWTER
CCC RETE 0 RETTR
etc..(thousands)

How permanently create record in sheets(1)choosing data in
sheets(2).
In empty (with in exception of heading) sheets(1) I'd like
make selection in column(2). When I select cell B2, appear
list all non-empty data in sheets(2)column(2).
When I choice YTWY other cells in row fillfill
automatically.

Name1 Name2 X Name3 (heading)
BBB YTWY 1 RWTER

Identically perform when I choice B3, B4 to B500 (in sheets
(1)).

How do it. Please help.
List in Data Validation don't work in another sheet.
I have excel 2k.
Thanks very much for any assistance.

Regards
Mark