Macro runs but does not separate data based on cell values

[AccountingJ]

Hello - I have the macro below that works for the most part.

What I would like for it to do is look at column "T", if that cell value = O and if "AD" is not null then return the value found on column 30, else return value found on column 3, both values would be in new sheet under "Amt1". If the cell value = I and if "AD" is not null then return the value found on column 30, else return value found on column 3, both values would be in the new sheet under "Amt2".

For some reason all values are returned on both "Amt1" and "Amt2". I also noticed if I take away the values on column "T" that it still returns some values.

Please Login or Register  to view this content.

[AccountingJ]

Think I fixed it - went over a few google/youtube vids.

Please Login or Register  to view this content.