Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
How to link cells only if...
Candy,
I have not seen your previous posts but I cannot understand from this one what exactly you are looking for. What do you mean by "linking"? Also, what do you mean by "go back to cell b1 and check it"? In general, you would be using a formula *somewhere* like =IF(A1="y", ___link___, ___don;t link___) But I don't even know if this formula should go to D1 or some other cell. And of course I cannot tell what should go to the 2nd and 3rd arguments. Please be more specific. Kostis Vezerides |
#3
|
|||
|
|||
How to link cells only if...
Thank you for responding. I am trying to create a shipping list. In my first column I have a list of items with an indicator for whether to ship that item or not. DESCRIPTION SHIP chair desk X table lamp X what I would like to do is link this information to my shipping list based on whether or not there is an "x". my shipping list should look like this desk lamp I need to create this list into seperate cells so that I can link to only the ones I need later. Again thank you for your time. Candy -- CNA48 ------------------------------------------------------------------------ CNA48's Profile: http://www.excelforum.com/member.php...o&userid=28686 View this thread: http://www.excelforum.com/showthread...hreadid=484051 |
#4
|
|||
|
|||
How to link cells only if...
Try the response to your later post in .worksheet.functions
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
How to link cells? | Excel Discussion (Misc queries) | |||
Can you Link 3 cells into 1 in Excel 2003 | Excel Worksheet Functions | |||
Can I link cells to a reference table I make? | Excel Discussion (Misc queries) | |||
Put same data in cells on two different worksheets (link?) | Setting up and Configuration of Excel |