VBA to Open a Template workbook and insert value from active worksheet

[raphagcwill]

Hello! Hope you all are doing alright.

I wonder if anyone could help me to acomplish a task thru VBA.

For starters I cannot right code, but i am pretty good at combining different solutions found on the internet and apply them to my need.

1 - I need a macro that looks in C column and macthes the values from C10 to lastrow with the values in T2 to lastrow.
If the match is true, then the macro will need to look in column U in order to know what clients have been found in the Column C.

The amount of characteres on the cells in C columns may vary, but I am only interested in the first 4 numbers

For each particular client found, i need the values in A1 and the amount for that particular match (E?) to be copied to the a template file found on my desktop.
The value in A1 should be copied starting from cell Q6 in the target file.
The amount for that particular match (E?) should be copied starting from cell C6 on the target file
Has the client several payments found, then these entries should be on the same file (Q7, Q8, Q9 & C7, C8, C9) and etc

The target files should then be closed and save in the desktop.

Hope I have managed to ilustrade what I need help with.

Thanks in advance