Multiple cell copy to a single cell

Closed

MikeR - Nov 10, 2017 at 05:04 PM
Blocked Profile - 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?

Multiple cell copy to a single cell
An example of a cell is a blank cell ✓ - Programming Forum
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
Clear only the formatting from the selected cell (leaving the content) - Guide
Based on the cell values in cells b77 - Excel Forum

1 response

Answer 1 / 1

Blocked Profile
Nov 10, 2017 at 05:09 PM

Take a look at the INDIRECT function and see if that can assist with one part of it:
https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261?ui=en-us&rs=en-us&ad=us

Post back with your thoughts.

Similar discussions

help me to add particular cells

If a cell contains any text then add a value

Highlight cell if another cell contains specific text

Counting cells containing only numbers

If cell = date return yes or no.

Similar discussions

Subscribe To Our Newsletter!