Posts by MickG

    Re: Highlight date clashes in Annual leave between staff


    Try this:-
    NB:- The colors will repeat after 10 date conflicts , so the same colour does not necessarily mean the same conflict.

    Re: show all combination from single column


    One Option:-
    Data in column "A" Result start"B1"

    Re: loop for Conditional Formatting Shapes based on value VBA


    Try this:-
    NB:- The name "Betty" appears to have an extra space in the Appendix/tracker sheets, so did not match the shape name until I altered it.

    Re: VBA or formula to use first and last value for duplicates cells


    Try this:-

    Re: VBA to reorganize and partially transpose data


    Try this for results on Sheet2.

    Re: marking repeat numbers in blocks of numbers in adjacent column


    Try this:-

    Re: VBA Find match and replace matched part of text string only


    Try this:-
    Data assumed to start "A2"

    Re: VBA for filtering with multiple criteria


    Try this:-

    Re: Employee Supervisor Hierarchy


    This is not the solution you perhaps hoped for , but the best i can do at the moment
    Results in sheet "Sample data" start "C1".

    Re: Employee Supervisor Hierarchy


    Try this in place of your previous code:-

    Re: Employee Supervisor Hierarchy


    This is my take, At the moment it just shows the Parent Child relationship, not the count.
    NB:- It differs somewhat from your results !!!!!