Forum Discussion
Solved
Copy and Pasting Temperamental When Copying Data From Multiple Cells into One Cell
Hello, So I work with a lot of spreadsheets and I copy data from one spreadsheet and paste it into another on a daily basis. Sometimes it allows me to copy data from three separate cells on one e...
Pasting multiple cells into a single cell will only work if the target workbook is open in a different instance of Excel than the source workbook. If the target workbook is open in the same instance of Excel, you won't be able to do that.
Pasting multiple cells into a single cell will only work if the target workbook is open in a different instance of Excel than the source workbook. If the target workbook is open in the same instance of Excel, you won't be able to do that.
HansVogelaar Thank you so much! I had no idea what an instance was but after googling it and learning how to open files under a different instance it now works as you suggested. Much appreciated!! Thanks again 🙂