how can i create link between two sheets

[samer aljayeh]

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

 

[Max]

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_twn_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)