Need help with insert row macro based on cell criteria

Hello,
I'm trying to create a macro that takes data from one row and inserts it into a new row.

Attached is a workbook with a before and after example of what I'm trying to do.

Each row has a security transaction that includes principal cash and interest. The data needs to be formatted so that each transaction has one row for principal and one row for interest.

Principal is identified by the tran code PAYDOWN in column C. Interest is identified by the tran code INT. However, the raw data generated includes both interest and principal under the tran code PAYDOWN.

There could be 100 or 1000 transactions generated based on the day. Any help would be greatly appreciated. Thanks

Hi

Run this on the Before sheet and see how it goes.

Please Login or Register  to view this content.

rylo

Wow!!! Works beautifully...Thank you!