VBA, Formatting data from Matrix to Vertical format

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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!