• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy Specific Columns from one worksheet to other Worksheet

santanukd

New Member
All,

Here is the requirement

Move the "Source" worksheet to "Target" Worksheet as below and add new columns in Target Sheet by Merging Columns from Source File

Source ColumnTarget ColumnNew Columns in Target sheet
CA
DB
EC
CONCATENATE("Job Code - ",Source!B2,CHAR(10),"Percentage - ",Source!G2)Target D Column
IF(Source!C2<>"","Checked","")Target E Column
IF(Source!C2<>"","High","")Target F Column
 

Attachments

  • Datasheet1.xlsm
    22 KB · Views: 5
santanukd
hmm?
1st Your thread is Move Specific Columns from one worksheet to other Worksheet
= eg A-,B-,C- columns move from Sheet Source to Sheet Target => after that Sheet Source don't have any data in A:C-columns - okay?
Next You write Move the "Source" worksheet to "Target" Worksheet as below and add new columns in Target Sheet by Merging Columns from Source File
= Move whole sheet Source to sheet Target ... almost as Delete sheet Target and rename sheet Source as Target
... adding is okay ... but then there are nothing in sheet Source ... hmm?

Or ... what did You try to write?
Your file looks different ...


Ps Employee IDs are random in both sheets ... should those be fixed?
 
I have updated the thread name. It is not move but copy specific columns from one sheet to other. And also create additional columns in target sheet based on data in target sheet
 
Last edited by a moderator:
santanukd
You should reread Forum Rules:
and after that ... follow those, please.
 
Back
Top