On select, Transfer the information to new Workbook (Excel 2003)

[Excelnoub]

I have looked in different web link and nothing that could help this situation.

I need to complete the transfer from one Workbook to another.

I have the following Code:

Please Login or Register  to view this content.

This transfer's the data to my "Archives" sheet in my original workbook. I have created a new workbook named "Archives.xls". I need the code to; Transfer the information when "cancelled" is selected to my "Archives.xls." document.

So instead of

Please Login or Register  to view this content.

it would transfer to my "Archives.xls".

Help would be nice

[Excelnoub]

I have also tried to Record the macro but using Excel 2003. It wont go from workbook to workbook.

[Excelnoub]

I recorded the following macro but I am lost in how to add this to my original code:

Please Login or Register  to view this content.