I have 3 workbooks one i want to use to store a running list of met criteria.

Workbook 1 is named "Wbook1", Worksheet named "DW Early" - and has a lot of data starting at cell A19 and contains n amount of data going down and across to AN.

Workbook 2 is named "Completed", Worksheet Named "Audits" - and contains data that i want to be an ongoing updatable list starting at Row B1.

Workbook 3 is named "UnAudited", Worksheet Named "Outstanding" - and contains data that isn't matched and is also an updatable list using just column A and starting at cell A1.

I have the routines in place to open the 2 worksheets (using a third controlling workbook containing the needed macros).

I have a text box (InputTextBox) in which will be entered string of data as this,for example : "1023-1204".

I need to enter some code to a CommandButton (CompletedCommandButton) which, when clicked, will compare the contents of InputTextBox with "Wbook1", Worksheet named "DW Early" column U, Row 19 and down using endxlup or similar (as the worksheet will have no fixed end of data).
If the value in InputTextBox is matched then depending if a variable (ColourSelect) = 1 then i want to paste the contents of the matched row onto the next empty row on "Completed", Worksheet Named "Audits", However if the value =2 i want the copied text to be green, value = 4 i want the copied text to be Blue.

If there is no match then i want to put the text in InputTextBox Onto "UnAudited", Worksheet Named "Outstanding" in the next empty cell down in column A.

Pleas could someone suggest the code i should use.

TIA