how the dta move from one excel to another excel based on date using MacroExcel vba

[suba777]

My requirement is how the data move from one excel to another excel based on date condition using Excel VBA.

I have two excel.1 Excel having master data and another is reporting excel. Master data having date,job number,status,start time and end time, etc...But i need only date ,job number,status,start time and end time based on date condition.I have designed in Reporting Excel 1 text box for date and 2 button for submit and cancel.

If i click the submit button in reporting excel, data 'll move from master data to sheet2 in reporting excel according to date condition.

Master data look like.

[arlu1201]

Your excel file didnt reach us. Can you try uploading the file again?