Hi,
I'm trying to create a tool which will allow common phrases/responses which are listed in a spreadsheet to be copied to a cell in another worksheet.
I have buttons at the side of the phrases/responses and my intention was to simply press the button and this would copy the text across.
It works fine when you are using just one response, the text copies over just fine, but there are certain circumstances where I might need to use 2 or more of these common responses at the same time, and when I tried to copy/paste more than 1 I got a debug error or nothng at all happened and the only text in the cell being pasted to was the original text copied into it.
I hope that makes sense. Any advice much appreciated.
Bookmarks