How can I copy a formated Excel table to auto-fill a Fillable PDF?

Question

I created an Excel VBA script to create a table that is in the same format as a fillable tax spreadsheet. I would like to copy the cells from Excel to the fillable tax spreadsheet, but when I try to manually paste the Excel table into the Adobe PDF, it pastes into one cell instead of all the cells. How can I fix this?

I have attached the fillable pdf and my Excel data. I would like to paste the Excel table into the large table on the second page of the pdf.

Eventually, I would like to script this in VBA, but I want to know how to do it manually first.

Thank you.

Test Screen Name · Answer

Possible as in "perhaps the pasted data could be programmatically parsed, split and assigned to appropriate fields". But I don't think so.

Certainly nothing you can do manually; you can put form fields in a grid in Acrobat, but there is no row or column relationship. They might look the same, but they need a completely different worldview.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.