Report

Multiple cell copy to a single cell

Ask a question MikeR - Last answered on Nov 10, 2017 at 05:09 PM by ac3mark
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?
Helpful
+0
plus moins
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.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!