I am trying to creat a shipping list from a set of 10 worksheets. There
are several cells that need to be linked to the shipping list only if
"x" is indicated in a particular cell in that column. I am able to get
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 the
first line. If there is no "x" then check the next line until it finds
an x and then link it.

Thanks in advance
Candy


--
CNA48
------------------------------------------------------------------------
CNA48's Profile: http://www.excelforum.com/member.php...o&userid=28686
View this thread: http://www.excelforum.com/showthread...hreadid=483683

Do I need more information listed so someone can help?


--
CNA48
------------------------------------------------------------------------
CNA48's Profile: http://www.excelforum.com/member.php...o&userid=28686
View this thread: http://www.excelforum.com/showthread...hreadid=483683

Try the response to your later post in .worksheet.functions
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--