Copy Template from one sheet to another based on condition

[Negi1984]

Hi All,

I have 2 sheets :
1) Details : Contains all the data.
2) Dummy Template : Contains standard list of data which needs to copy from this sheet to Detail sheet

Logic :- 1) Check minimum lowest date in Details sheet in Posting date( column I). and identify that lowest date weeks Monday date.
Now we need to copy paste the template from Dummy Template sheets by repeating Point 1 Mondays date till Current weeks Mondays Date.

For Example : Minimum Date in Details sheets is 03-DEc-18, now we calculate Monday on this week and which is same 03-Dec-18.

Now we copy all the row from range A2:AJ17 and paste in Details sheets in bottom of last records. At Posting date will be start from 03-Dec-18. then repeat copy paste same rows A2:AJ17 till current week.

Sample file is in below given link

https://1drv.ms/x/s!Ap80Ku6M2Tw5gUOYV-OcgcvjfFU_

Thanks in advance for your valuable support.

Regards,
Rajender

 

[Negi1984]

Hi,

Can anybody help me out ?

 

[Logit]

.
Your link is bad.

 

[Negi1984]

Hi Logit,

Below is the updated link.

https://1drv.ms/x/s!Ap80Ku6M2Tw5gUOYV-OcgcvjfFU_

.
Your link is bad.

 

[Logit]

Still bad ...

 

[Negi1984]

Hi,

I hope this time it will work ?

https://1drv.ms/x/s!Ap80Ku6M2Tw5gUMv_OWFjzybIW8s

Still bad ...