Hey Friends!
I have a list of 'default' responses my team should be using when sending an item back to one of our vendors. To speed things up, I am going to send the list out to my team, and have them start using these responses instead of custom responses that they type out. I want this to be really simple to use, to where you just have to click on one of the responses, and it auto copies to the clipboard for pasting in another program.
I have about 15 responses for now, and I'm sure more will be added - I've created a macro for all 15 of the responses currently in the form of a button next to each response. When the button is clicked, it copies the text next to it. This works - but will be pretty annoying if more responses are needed. Is there a way I can make ANY cell, once selected, copy the text within without the use of buttons and separate macros?
The workbook only has one sheet with all values contained within column A.
I appreciate all your help in advance!!!
I have a list of 'default' responses my team should be using when sending an item back to one of our vendors. To speed things up, I am going to send the list out to my team, and have them start using these responses instead of custom responses that they type out. I want this to be really simple to use, to where you just have to click on one of the responses, and it auto copies to the clipboard for pasting in another program.
I have about 15 responses for now, and I'm sure more will be added - I've created a macro for all 15 of the responses currently in the form of a button next to each response. When the button is clicked, it copies the text next to it. This works - but will be pretty annoying if more responses are needed. Is there a way I can make ANY cell, once selected, copy the text within without the use of buttons and separate macros?
The workbook only has one sheet with all values contained within column A.
I appreciate all your help in advance!!!
