writing a macro in excel 2003

[swe1]

Hi all,

I am new to writing macros.
Please help me to write a macro for copying the last row(latest one)
from one workbook and pasting it in as a new row at the end in another workbook and rename this workbook with the sys date.

Thanks.

[royUK]

You need to explain more clearly

[swe1]

Thanks for replying.

From the weekly stats report i need to select the Last line on this Tab having the current Monday’s date and the number of AOR’S.
Select this last line and copy.
Next,Open the AOR Summary Spreadsheet in my current folder
Go to the last line in the summary Spreadsheet and Paste the date/num i obtained from the AOR tab on the weekly stats file Spreadsheet
Rename the AOR Summary spreadsheet with the current Monday’s date
(format: AOR Summary mm-dd -yy)

[swe1]

Please help!