You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hi there. I am looking for a formula that allows me to select of tick text to determine whether it is copied to another cell on another sheet.
For example, some styles I need note: specification....., while others I don't. I would like to be able to tick a box or something similar to allow this note to show on another sheet.
Is this possible?
iMac 24″, macOS 12.5
If you don't need the text color or boldness to be unique or different for each message, you could use a popup menu.
In a table somewhere make a column of all the messages you want in your popup menu. Arrange them in the order you want them. Select them all plus one blank cell and change the format to Pop-up menu. Copy the blank cell and paste it in the cells that might need a message. Now you can choose the message from the list that pops up when you select the cell.
Inthe screenshot below I selected cells B2-B5 and formatted them as pop-up menu. I copy/pasted B5 to D2. I then clicked on D2. I can choose any of those messages from the list and it will appear in D2. You can set the format of the cell to be bold or orange or whatever but all messages will get that same format, it will not be individualized for different messages.
If you need to edit a message or add a new one to the list, select them all again, change the format to Text, make your edits and/or additions, then follow the same steps as before to make a new popup and copy/paste it to the places that need the new one. The existing popups from before will not be affected by the changes (unless you copy/paste over them with the new one).
If you don't need the text color or boldness to be unique or different for each message, you could use a popup menu.
In a table somewhere make a column of all the messages you want in your popup menu. Arrange them in the order you want them. Select them all plus one blank cell and change the format to Pop-up menu. Copy the blank cell and paste it in the cells that might need a message. Now you can choose the message from the list that pops up when you select the cell.
Inthe screenshot below I selected cells B2-B5 and formatted them as pop-up menu. I copy/pasted B5 to D2. I then clicked on D2. I can choose any of those messages from the list and it will appear in D2. You can set the format of the cell to be bold or orange or whatever but all messages will get that same format, it will not be individualized for different messages.
If you need to edit a message or add a new one to the list, select them all again, change the format to Text, make your edits and/or additions, then follow the same steps as before to make a new popup and copy/paste it to the places that need the new one. The existing popups from before will not be affected by the changes (unless you copy/paste over them with the new one).
Amazing! Thank you so much!
Formula for text insert
