Copy and Paste Macro

[FM1]

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.

[Richard Buttrey]

Hi,

Macros code as follows to achieve all three:

Please Login or Register  to view this content.

HTH

[shg]

Please Login or Register  to view this content.

[FM1]

Hi,

Macros code as follows to achieve all three:

Please Login or Register  to view this content.

HTH

Please Login or Register  to view this content.

Hi guys. Both macros worked perfectly (just operate in different ways). Thanks very much for your help.