VBA, Formatting data from Matrix to Vertical format

  • Hi all,

    My current state of macro opens my text files in excel(via file picker) and delimits them.
    However now they are in a matrix format and would like to get them in a more legible format.

    My current format:

    [Blocked Image: http://i.imgur.com/7ckM5dF.jpg]

    Desired Format:

    [Blocked Image: http://i.imgur.com/hmIRubX.jpg]

    this format is continue down the page and repeats.
    A1 is needed and stays the same for several matrices then changes.
    A5:A7 is the same for each batch.
    B5:B7 changes each batch. (first name)
    L10:L24 change each batch, (last name)

    Numbers in matrix will change for each person.
    Values circled is actually what needs to be extracted.

    My current code:

    Any help would be greatly appreciated.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!