Last Row Macro
 

I need a macro which will always copy the last row of every sheet an
paste on the last row + 1 of the individual sheets.

I record the macro but that is not what I want and I don't know how t
modify the macro to make it works.

Can someone help?

Regards
Michae

--
Message posted from http://www.ExcelForum.com

Last Row Macro
 

lrow = ActiveSheet.UsedRange.Row _
ActiveSheet.UsedRange.Rows.Count
Rows(lrow).Copy
Rows(lrow + 1).Insert

That enough to get you started? - Piku

--
Message posted from http://www.ExcelForum.com