View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default how can i create link between two sheets

"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
---