Concatenate columns and paste on in another worksheet column

Hi

1. I am trying to Copy few columns from Source worksheet to Final worksheet
2. Concatenate few columns of Source and paste in one column of Final Worksheet

Here is the code I am trying somehow not working the concatenating part

Please Login or Register  to view this content.

Her is the revised file. Please refer the Final worksheet

Works like a charm. yes formatting will be helpful. Also if there is no Final sheet available it should check and create

Originally Posted by Rick Rothstein

The following code will move the data you want moved, add the text and concatenate the column you want to a sheet named "Final" which is assumed to already exist. The code does no formatting. If you want formatting, let me know and I'll add code to make it look like, I'm guessing, your example "Final" sheet?

Please Login or Register  to view this content.

Thank you so much buddy.

Here is the last bit to make it what I want

1. Like you have combined data in "Final" D column with "Source" G column and returned in Final D column

Similarly I need "Final" E column with "Source" H column and returned in "Final" E column

2. I want the Column F for "Final" worksheet to return as "yes" if Final A Column is not blank

3. I want the Column G for "Final" worksheet to return as "Medium" if Final A Column is not blank

Originally Posted by Rick Rothstein

Replace the macro I gave you earlier with this expanded macro and see if it does what you want...

Please Login or Register  to view this content.

Hi Rick,

I agree with you.

As we are almost done with this requesting to help.

Added the file again and included comments in the Final File. I am sure a quick change for you.