if i want to registar someone in sheet1 with condition of if this person in
level 2
his name must appear in sheet 2 in specific schedual

"samer aljayeh" wrote:
if i want to register someone in sheet1
with condition of if this person in level 2
his name must appear in sheet 2 in specific schedule

Venturing a guess here ..

Try this sample construct (from my archives):
http://savefile.com/files/8936561
Auto-Extract_Data_to_Own_Sheet_by_Category.xls

Adapt to suit .. The key "Cat" column in the sample would correspond to,
in your case, the key column housing the levels, eg: level 1, level2, etc)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---