User Input Form to worksheet

First off thanks for answering my first question so quickly.. hopefully this will be my last one..This one is a little bit trickier

(these two files are seperate but in the final version they will be combined)
I have attached a userinputtest.xls file that has the form that i want to enter data from (you have to go to the vb part to make it run)

The test.xls file is the sheet that I want the data to be entered into but in a certain way....

You will see that there are different inputs such as route number, settlment date, date of route, beginning variance, and ending variance.

When the user clicks add route on the input form I want it to first
1. Search row 1 for route number you are adding..
2. If route number does not exist I want it to create a column set for that route(if you open file you will see what I am talking about)
3. If the route does exist I want it to find the same row as the settlement date entered and then the date of route... and i want it to enter the beginning and ending variance.

Basically the only data being put into the worksheet is beginning variance and ending variance.

Thanks.