Trouble converting a fully functioning Excel workbook to a fillable/autofill PDF

Question

Hello,I currently use a fully functioning Excel workbook for my SMEs to use to submit their work.  This includes them selecting their name and the cells autofill with the rest of their information.  They are able to do this with our contractors and buyers as well.  Then they have unlocked cells to fill in additional information.   I cannot find any information to make this transfer from Excel to a working PDF smooth or consistent, and I have no clue how to write code.  Am I missing something, or do I need to build this form from scratch?  If from scratch, I still cannot find how to create autofills when information is entered in one part of the PDF and filed to other sections of the PDF, and proper drop down lists that autofill information. in the PDF. I am using Adobe Acrobat Pro. Thank you SO much!

try67 · Accepted Answer

Yes, you would have to re-create all the form fields and write the script to populate the data based on the input in those fields.

There's an abundance of information on this forum and on various others on how to do all of that, including some paid-for websites that provide detailed information.

Here are a few free tutorials to get you started:

https://acrobatusers.com/tutorials/conditional-execution

https://acrobatusers.com/tutorials/change_another_field

https://acrobatusers.com/tutorials/show_hide_fields

https://acrobatusers.com/tutorials/how-to-do-not-so-simple-form-calculations

https://acrobatusers.com/tutorials/js_list_combo_livecycle

https://acrobatusers.com/tutorials/list_and_combo_in_lc