Copy and Paste Macro

Hi everyone. I need some help on a copy and paste macro. Basically I need the macro to perform a few actions:

1. In whatever cell is selected when the macro is run, enter a new row.

2. Copy the information from the row directly above the new row and paste (values, formulas, formats, etc) into the new row.

3. Return to column P in the new row, i.e if the new row is row 11, then return to P11, for row 12 return to P12, etc.

I have tried recording the macro but because it is hard coded to specific rows, its not working.

I have attached a sample copy of the sheet (had to zip due to the size of the file). Any help will be greatly appreciated. Thanks in advance.

Please Login or Register  to view this content.