Results 1 to 2 of 2

Thread: VBA for Matrix

  1. #1
    Acolyte TTTT's Avatar
    Join Date
    Jul 2018
    Posts
    20
    Articles
    0
    Excel Version
    365

    VBA for Matrix



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,
    Hope everyone is great! I was wondering if there was someone amazing out there who could help me with a macro to help convert the attached.

    In the Position Requirements Matrix any modules (row 2 and 3) that appear in the matrix with an "x" in the grid against values down column A (eg. employee code) to appear in list view in the Upload tab

    Hope this makes sense? Let me know if you need more information and thank you in advance for your helpPRM Uploaded.xlsx

  2. #2
    Acolyte TTTT's Avatar
    Join Date
    Jul 2018
    Posts
    20
    Articles
    0
    Excel Version
    365
    Sorry I also forgot to mention, the blue shading means (Mandatory) and the orange means Desirable, so if it makes things easier this can be changed from noting 'x' to 'E' for Essential and 'D' for Desirable

Posting Permissions

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