Hi AB33,

Sorry again, probably i was not able to explain properly. If you carefully observe my template and code, i need both these headers to be pasted to respective location with a gap of 15 rows. ie. A1:N1 is to be copied at A16:N16. I have named A1:N1 as 'named range' as "Header". Same way A4:N4 is to be copied at A19:N19 which is named as "Child". This process should continue upto say next 500 rows by maintaining same gap of 15 rows. Note that data in between rows should not get erased while running this copy of the headers.

Hope you have got what i mean. Thank you in advance for reply again.

Look forward to receive suitable suggestions.

Best regards,

Nandula