VBA Macro on copy pasting from one workbook to another with loop and conditions

[hencra]

[TABLE="width: 320"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD]Hi, [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]Can you help me with my problem, I want to automate the creation of a DTR given the schedule they have. I have the file where the schedule is in together with all other information called "DTR Creator" and a "DTR Sample" where the cells will be copied. I need to create N numbers of DTR equal to N numbers of employee[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"] Things i need to copy;[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]Name of the employee from E3 up to the last row with data to be copied at D4 of DTR sample workbook[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Date from H1 up to the the last column with data with 2 column spaces, so H1, J1, L1 etc to be copied from A9 to the last row with data of DTR Sample[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]We have three shifts, 8M, 8N and 8T and blank if dayoff[/TD]
[/TR]
[TR]
[TD="colspan: 5"]I have 4 columns in DTR sample where different conditions are needed for different shifts[/TD]
[/TR]
[TR]
[TD="colspan: 3"]Scheduled word hours[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]Total Worked Hours[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Total ND Hours[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Remarks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8M[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]Needs to have 8 under the scheduled hours column. data will be known from DTR creator H3 inline with the date, next is on J3 etc to be pasted on B9 downwards until there is data available[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Total worked hours is 8 and should be pasted from f9 downwards on DTR Sample[/TD]
[/TR]
[TR]
[TD="colspan: 3"]Total ND hours is blank [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Remarks is blank[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8N[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]Needs to have 8 under the scheduled hours column. data will be known from DTR creator H3 inline with the date, next is on J3 etc to be pasted on B9 downwards until there is data available[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Total worked hours is 8 and should be pasted from f9 downwards on DTR Sample[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Total ND hours is 8 and should be pasted from g9 downwards[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Remarks is Night Diff and should be pasted from h9 downwards[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8T[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]Needs to have 8 under the scheduled hours column. data will be known from DTR creator H3 inline with the date, next is on J3 etc to be pasted on B9 downwards until there is data available[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Total worked hours is 8 and should be pasted from f9 downwards on DTR Sample[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Total ND hours is 3 and should be pasted from g9 downwards[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Remarks is Night Diff and should be pasted from h9 downwards[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]After that, the dtr sample will be saveas with the name of the employee being copied then close and then goes next to the next row of the employee name like a loop until there is no more data. [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]Thanks in advance![/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]