Tweeking Workbook VB formula problems (Excel 2003)

[Excelnoub]

Here is my workbook:

Final001.xls


I have a couple of glitches that needs to be fix before I get this to production:

1: If you follow the process and make around 5 dummy example but don’t select “yes” right away then once completed you add what ever row you like…

Example:

Row 5 = Test1 is transferred
Row 7 = Test3 is transferred
Row 9 = Test5 is transferred

Then go on the second tab:

Test1 should be in row5
Test3 should be in row6
Test5 should be in row7

Then transfer only Test3:

Test3 should be on row5 on the “Evaluation” sheet

Then go back to Sheet1 “Pre-requisition”

When you select Test2 and select “yes” is will not go to the next available row… This goes for every sheets except for “Pre-Requisition” and “Archives”. What am I missing? 

2: When information is transferred from Sheet1 to sheet2, then sheet3 in sheet2 column D doesn’t want to clear but it has the following at the end of Sheet2’s code:

Please Login or Register  to view this content.

Any help would be appreciated as this is the final version

Thank you in advanced

[Excelnoub]

Solved from another thread.