Macro to copy data from 3 cells & paste in one cell

Easy enough to do, but we need to know which workbook will have the code... the source or the destination?
It would be good to know which cells are being "copied" too, and which cell is receiving the data. This part is not necessary but you will have to do more editing if you don't specify that.
Also do we just concatenate, or do you want a space or some other character in between the values of the 3 cells.

Here is one way
- another workbook is opened (Wb2)
- cells A1, B3 & C5 in sheet "RawData" (in workbook containing the macro) concatenated and value placed in a first sheet in Wb2
- amend to match your own requirements

Please Login or Register  to view this content.

Hi Arkadi,
You have asked very valid questions. You are champ!

The code will be in the destination file. Also I already have a macro (in destination file) that asks me to select source file & then it copies some data from source file & puts it into destination file. I want to edit the same code to cover the above requirement.

I have Name, Middle name & Surname in 'Promoter' tab of the source file in cell A2, B2 & C2 respectively. I want the same to be concatenated with space between Name, MiddleName & Surname & pasted in cell A12 of destination file 'MgmProf_GroupCo_FLC' tab.

The above is for 1 entry only. There would be additional entry in source file in cell A3, B3 & C3. I want the this another entry to be pasted in cell A13 of destination file. Similarly there would be additional entries in source file below row number 3 till row number 11 (10 names). All these should get pasted below A12, A13, A14,..... in destination file.

If there are less than 10 names, I am ok if the macro copies even the blank cells & pastes the same in destination file.

See if this does the trick:

Please Login or Register  to view this content.

Glad I could help, and thanks for the rep. If you would be so kind, please mark the thread as solved? Thanks in advance