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