Auto-export worksheet to form fillable PDF using a macro button

Hello,

I've created a worksheet that allows my team to build an order for a customer. I've created a PDF form with blanks so they can fill in the necessary values in the correct fields ie. Tariff Name, Handset Name, Minutes etc.

I'm hoping to create a macro button that will export all the the data needed and auto fill the PDF form to save time.

So far I've added a button with the following code

Sub CopyData()


Sheets("Quote").Range("v16:ab16").Copy
Sheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues

End Sub

This simply adds all the data needed onto a separate sheet ready to be exported as a csv.

I'm in need of the rest of the code to export/import Sheet1 into my fillable form.

So far attempts to export to .csv have turned my entire worksheet into a .csv file or caused errors within the code.

I've attached a sample of my Workbook and PDF form below.

Sample Documents

Excuse the messy worksheet. I'm going to tidy it up once I've cracked this.

Thanks,

Sabri

I've found a few posts online that suggest a program called iTextSharp will allow me to do the above?

Is anyone familiar with this program? And if so do you know if this will work/how it works?

Thanks,

Sabri

In case it's useful to anyone else, I've managed to solve my issue.

Details and example files can be found on a thread I created on another forum.

OZGrid - Auto-export worksheet to fillable PDF form using a macro button

Sabri