Create new sheet from data available by VBA

[luonghongquang]

Hi everyone, I want to create commercial invoice and packing list using available template. I have consulted VBA but almost can not solve pre enter data into a sheet or userform.
Is there any way to get the existing data to create a spreadsheet like the one below?

 

[MikeVol]

I have consulted VBA but almost can not solve pre enter data into a sheet or userform.

Is there somewhere we can see what you were trying to do?
Upload a sample file with your code and a couple of lines of data (delete confidential data) to some file sharing service and share the link in this thread. We'll see how we can help you. Good luck.