Append data from row of one workbook to row from another workbook

[dip11]

Hi,

I have 2 workbooks each with 1 sheet.

The commonality between these 2 workbooks is that each row has a unique identifier.
I would like Excel to append the data from one row to that of the other if the identifier matches.
I also would like to be able to say from which date onwards it should try to match identifiers so that it doesn't overwirte old ones.

Appended data should be added into the correct row in column CT onwards.

It would also be great that if in workbook2 the identifier was named "U", a new row would be created in workbook1 that started in CT with that information.

I have attached an example workbook with desired outcome

Thanks in advance

[dip11]

Anyone able to help please?

Let me know if something's unclear so we can work towards a solution together.
Really would like some assistance as I have no clue how to do this as a loop with an input box and all.

[dip11]

Any insights please?

[arlu1201]

So as long as the entry in column AT in workbook2 matches column D in workbook1 and the data falls within the inputbox date and today, that data should be copied to workbook2?

Which columns from workbook1 should be copied to workbook2?

[dip11]

Hi arlu,

From Workbook2, take Columns A-AT (i.e. don't copy the matcher column but everything else) and fill them to Workbook1 Column CT.

So Workbook1 Column CT = Workbook2 Column A
Workbook1 Column CU = Workbook2 Column B

etc