Match a cell with text box on worksheet and write data

I am attempting to loop through a workbook find the date that matches the date on my userform textbox then write data to specific cells. The cells are in various places on the sheet. I having also been searching for a way pull the same data from last years workbook for that same day (a year ago).
I would like all of this to happen when a command button is to save the sheet.
I have attached the workbooks and here is code I have been working with:

Please Login or Register  to view this content.

DAILY REV PR exaample.xls2012 revenue example.xls

I think this a little closer But I am still getting a FOR WITHOUT NEXT error
Any Help would be much appreciated

Please Login or Register  to view this content.