Multiple cell copy to a single cell

MikeR - Nov 10, 2017 at 05:04 PM - Latest reply: ac3mark 9919 Posts Monday June 3, 2013Registration dateModeratorStatus July 16, 2018 Last seen
- Nov 10, 2017 at 05:09 PM
Hello,

I am trying to copy the contents of multiple cells in workbook A to a single cell in workbook B. This worked fine in the 2010 version but, the 2016 version will not allow it. as soon as I click into a cell on workbook B the copy function is killed. I am able to make it work by using the clipboard however, the contents are the result of a vlookup and once the contents are copied to the clipboard the values are automatically pasted over the vlookup formula.

Any ideas?
See more 

Your reply

1 reply

ac3mark 9919 Posts Monday June 3, 2013Registration dateModeratorStatus July 16, 2018 Last seen - Nov 10, 2017 at 05:09 PM
0
Thank you
Take a look at the INDIRECT function and see if that can assist with one part of it:
https://support.office.com/en-us/article/INDIRECT-function-474b3a3a-8a26-4f44-b491-92b6306fa261

Post back with your thoughts.
Respond to ac3mark