Conditional links

[CNA48]

I am trying to creat a shipping list from a set of 10 worksheets. Ther
are several cells that need to be linked to the shipping list only i
"x" is indicated in a particular cell in that column. I am able to ge
the cell I want to link by using the following formula
=IF(Sheet1!S10="X",Sheet1!E10," ")

How can I list only the lines with "x"?

I do not want to link only 1 line at a time. I want it to check th
first line. If there is no "x" then check the next line until it find
an x and then link it.

Thanks in advance
Cand

 

[CNA48]

Do I need more information listed so someone can help

 

[Max]

Try the response to your later post in .worksheet.functions