Posts by laurahd

    I am trying to create a macro to do the following steps on a report, but I am having trouble with the if/then statements. Can anyone help me create a macro that would do all of these steps? Is it even possible to do this?


    Select All

    Sort by Column A

    If Column A is not equal to "1", then delete entire row

    Format Column J to $

    Select All

    Sort by Column L

    If Column L is equal to "VOID", then delete entire row

    If Column L is equal to "CREDIT", then change column J to a negative number

    Select all

    Sort by Column K

    Insert 5 rows under all rows that Column K is equal to A (to create a grouping of everything that equals A)

    Insert 5 rows under all rows that Column K is equal to D (to create a grouping of everything that equals D)

    Sort by Column J of all rows that Column K is equal to A

    Sort by Column J of all rows that Column K is equal to D

    Sort by Column J of all rows that Column K is equal to M or D

    Autosum Column J of all rows that Column K is equal to A

    Autosum Column J of all rows that Column K is equal to D

    Autosum Column J of all rows that Column K is equal to M or D

    Insert new column after Column J

    Copy Column J

    Paste into new Column K


    Thank you!!