R
rbricelda
Hello,
I have looked all over for a solution to this problem and no luck so far.
I want to format/activate a cell to allow a copied range of cells (or multiple cells) from a separate workbook to paste into the one formatted/activated cell.
I know to copy the multiple cells, then open the clipboard, press F2 (to activate the cell)and then paste. I want to eliminate the steps and just copy the multiple cells and paste them to one cell.
If this required VBA I will need step by step instructions.
PLEASE HELP!!!
I have looked all over for a solution to this problem and no luck so far.
I want to format/activate a cell to allow a copied range of cells (or multiple cells) from a separate workbook to paste into the one formatted/activated cell.
I know to copy the multiple cells, then open the clipboard, press F2 (to activate the cell)and then paste. I want to eliminate the steps and just copy the multiple cells and paste them to one cell.
If this required VBA I will need step by step instructions.
PLEASE HELP!!!