VBA to copy highlighted line and paste below the highlighted line-essentially duplicate it

Hi All!

I have a list of accounts I have to send a customer so they can indicate whether each account is Y exempt, N not exempt or P partially exempt. When the account is partially exempt, I need to have some sort of prompt in place that forces the customer to fill in the specific records (within the account) that are exempt.

Once a Y, N or P is indicated on the master sheet, it automatically populates its own sheet in the same workbook. If a P is indicated next to one of the accounts, I need the customer to be able to add the specific records somewhere and have it populate in the "P sheet".

My idea was, that I would have a conditional formatting in place to highlight all partial accounts (P) in the master sheet, and then copy the row and insert its copy below it. There would be a record column next to the row also where the customer could fill this in.

If anybody has any suggestions, or could help me copy from the highlighted row, please please please help!!

Very much appreciated!

KT Please post a spreadsheet.