Results 1 to 5 of 5

Copy user mentioned column from first sheet to another mentioned column in second sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    3

    Copy user mentioned column from first sheet to another mentioned column in second sheet

    Dear Friends,

    Here is the problem statement:
    I have the first data sheet called "data" which has multiple columns. I want to copy certain columns from this sheet to H1 and H2 depending upon the mapping provided in the mapping sheet.

    If the mapping looks like:
    From Data to H1
    B A
    then i want to copy the contents of column B from "data" sheet to column A of "H1" sheet

    I have uploaded the excel doc on how the output should look like.

    Would appreciate if someone can share macro/sample code/sample excel sheet on how to do this.

    Regards
    rpatil
    Attached Files Attached Files
    Last edited by rpatil; 10-11-2012 at 12:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1