Linking two sheets

I have a sheet that has a code in it that returns a symbol. On a second sheet I am trying to ask it to tell me if something is checked on the first sheet to return some text. I tried a if statement, that didnt work. It would be easier if I could somehow link the two that if one item is checked it automatically sends the info to the second sheet. Can anyone help?

Will a trigger do? You'd put this code into the Sheet that has the action occurring.
Change the $b$2 to the cell that is being checked
Change the "c" to the value that should trigger

Please Login or Register  to view this content.

Will this work when I have multiple cells that are being checked and I need the information triggered to appear in another worksheet within the same workbook?

You can take any action if the trigger matches the criteria.
So if you want the trigger to put stuff into 3 separate worksheets, you'd just add those items.
You can check for multiple items in the one sheet by checkingon the Target.Address value and then take different actions based on the trigger's target. sample below
The code needs to be in the worksheet in which the trigger occurs though. So if you want to see if something got selected on another sheet, you'd need similar code in that other sheet.

Please Login or Register  to view this content.