Posts by Stelli1989


    i've got an excel file which contains more than 50 worksheets. All of them have the same first labeling line.

    I am trying to get a vba to work which searches each worksheet for following criteria:

    When a Cell in Column A is not empty then check if Cell in same row on Column K and L is empty. If one of them is not empty do nothing.

    If both of them are empty check if Column M is empty.

    If Column M is empty, check if Date in Column D is max. 3 days in the future Then jump to this row.

    Else check next row until all Worksheets are done.

    If there are no cells which meets the criteria a MsgBox should appear to confirm that no unfinished rows exist.

    I would thank you For any suggestions.