View Single Post
  #1   Report Post  
CNA48
 
Posts: n/a
Default How to link cells only if...


In cell a1 I have an option for an "y" "n". Based on that cell I want
to link cell b1 to cell d1. If it is "Y" then link it, if it is "n"
then I want it to go to cell b1 and check it and so forth. I only want
to link the items in column "b" that have a "y" next to them. I can do
this for one cell and even skip and go until I find the first "Y".
What I can not do is make the second link start after it has found the
first "y" in column "A". Can anybody please help. This is the 3rd
time I am asking for help. I have searched and haven't found what I am
looking for. Yes I am a noob to this particular forum but I have never
had this much trouble getting an acknwledgment of my question, much
less an answer. So please if there is something I am doing wrong in
here, let me know. I know everyone is helping of their own free will,
and believe me it is appreciated.

Candy


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