Populate data in form

Hello Good day!
Anybody want to help.
I have data that came from other workbook.
I manually input those data into the form sheet then print it.
Is it possible to automate this job?
I will copy and paste the data into "Input sheet" then populate to form in "form Sheet".
Example:
Range A2:J2 will populate to form 1 (C4:L4)
Range A3:J3 will populate to form 2 (C22:L22)
then automatically add form depends on the number of data in put sheet.

Thanks in advence

Hi,

see if this helps you.

Hello Admin.
Thank you. Unfortunately, i don't know how to use your formula.:confused:
I am still a newbie in excel.
Thanks

Hi

I have illustrated in the attachment how to create name ranges.

HTH

Quote:

---

Originally Posted by Admin

Hi

I have illustrated in the attachment how to create name ranges.

HTH

---

Thank you so much Admin.
I have learned new techniques in excel because of this.