Copy / Paste range from one sheet to another, if cell in column A is not blank

Dear friends,

I am trying to write macro, which will copy/paste default range to column B, if cell in column A is not blank.
Let me explain it as follows:

1. I got 2 tabs in my workbook (Sheet1 & Sheet2)
2. In Sheet1 I have data in column A (data are filled every 49 lines, e.q.: A1, A50,A99,A148 ....
3. In Sheet2, I have one range (basically there is a template of invoice available for printing). This template has 49 lines (from column A1-O49) and its named as range as: Invoice_template

What I need to catch is following result:
If cell in column A (in Sheet1 )is not blank, then copy range Invoice_template from Sheet2 and paste it into column B in Sheet1.


Many thanks for any help and advise from your side.

Thank you

Oh, ti works perfectly. I really appreciate your quick response and excellent help.

Once again, THANK YOU

Yes, sure, I'll do it.