Results 1 to 4 of 4

Thread: VBA Copy columns with non-similar header name between two workbooks
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2018
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default VBA Copy columns with non-similar header name between two workbooks

    Hi there,

    how can i make a condition to copy then insert a column to another workbook,

    the only condition is that, if this columnd header exists in the current workbook dont copy it !

    EXAMPLE:

    workbook1

    Name Age City Email

    Workbook2


    Name Title Age Salary

    so when i copy from "Workbook2" to "Workbook1" ==> i will get

    New Workbook1

    Name Title Salary Age City Email


    hope am clear

    thank you.

  2. #2
    New Member
    Join Date
    Nov 2018
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: VBA Copy columns with non-similar header name between two workbooks

    Quote Originally Posted by AbdulkareemAlhassni View Post
    Hi there,

    how can i make a condition to copy then insert a column to another workbook,

    the only condition is that, if this columnd header exists in the current workbook dont copy it !

    EXAMPLE:

    workbook1

    Name Age City Email

    Workbook2


    Name Title Age Salary

    so when i copy from "Workbook2" to "Workbook1" ==> i will get

    New Workbook1

    Name Title Salary Age City Email


    hope am clear

    thank you.
    One important thing that

    Name and age should be a way to copy the data from the other columns !

  3. #3
    New Member
    Join Date
    Nov 2018
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: VBA Copy columns with non-similar header name between two workbooks

    Quote Originally Posted by AbdulkareemAlhassni View Post
    One important thing that

    Name and age should be a way to copy the data from the other columns !
    guys no need for this only the first post

  4. #4
    New Member
    Join Date
    Nov 2018
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: VBA Copy columns with non-similar header name between two workbooks

    Quote Originally Posted by AbdulkareemAlhassni View Post
    Hi there,

    how can i make a condition to copy then insert a column to another workbook,

    the only condition is that, if this columnd header exists in the current workbook dont copy it !

    EXAMPLE:

    workbook1

    Name Age City Email

    Workbook2


    Name Title Age Salary

    so when i copy from "Workbook2" to "Workbook1" ==> i will get

    New Workbook1

    Name Title Salary Age City Email


    hope am clear

    thank you.
    am really stuck here
    x(

    please help

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •