Posts by saechu

    I'm new to VBA and am trying to figure out a way to do the following.
    I have 3 spreadsheets (Live, Control, Compare). Live & Control have a list of names in D8:D99 and Compare has a list in A7:A98 with a number field in B7:B98.
    I want to create a toggle button that will hide rows based on the criteria below (as well as unhide all rows if clicked again).
    - If value in B is 0 AND
    - Name in Compare is on both Live & Control lists

    If the name in B7:B98 is missing from either Live or Control list or the value > 0, I do not want to hide the row.

    Any help would be greatly appreciated. Thanks!