Automatic Splitting of cells based on example; using expanded definitions as per scripting dictionary/look up + copy pasting into next available column

  • Hi guys,


    I need to transform a data input from the attached example as per follows and struggle to write a script that would cater for such needs. Please see the attached.


    The data shall be copied from "original" and the columns should be split as "transformed" based on the information in the "key" sheet.


    The loop should then run row by row and next line shall be inserted into next available row as illustrated on example in attachment.


    Many thanks for your guidance!


    Regards,


    Tee

  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too.

  • If I've been helpful, let me know. If I haven't, let me know that too.

  • Okay, Let me actually introduce you to the full issue that i am having as I am struggling to accommodate the suggested code in a flexible way.


    I am trying to create a script that will add records from original file to newly built template as per attached.


    Please note that some of the columns have strings that need to be split and one of them uses the dictionary that I attached before.

    Also, the next record always have to be pasted in the next empty row :S


    If you could add the comments it would help as well as I am learning this part of VBA...many thanks!


    Your help is immensely appreciated!