Selectively merging Columns from two notepads into one using VBA RRS feed

  • General discussion

  • Hi All,

    I have 2 Notepads files having data .I want to merge some of the columns selectively from them to one single notepad. Also, I wanted to merge column values into one and then write that to the output file.

    FName,LName,AccountNo,ChasisNo,DrivingLicenseNo,PolicyNo,RegNo1,RegNo2---Columns of 1st notepad

    File Size is 10k

    Other desired columns are
    DOB , SysDate etc. ---These can be taken from file of size 1k(file is basically an existing output file, as these values doesn't change ,so can be copied from there)

    The order  of the columns of final notepad should be:

    FName, LName,DOB, RegNo(merged one),DrivingLicenseNo,PolicyNo,ChasisNo,.etc(size required is 1k)

    Can somebody provide some solution for the same.

    Thanks in advance.

    • Changed type Bill_Stewart Monday, October 2, 2017 10:01 PM
    • Moved by Bill_Stewart Monday, October 2, 2017 10:02 PM This is not "scripts on demand"
    Wednesday, August 30, 2017 12:37 PM

All replies