I have a set of separate PDF forms with multiple blanks. There are 13 forms. All forms have a few fields in common but the rest are specific to each form. I would like to place each form in an individual worksheet inside a workbook and have a single worksheet that has blanks that can be entered to populate the blanks in the forms. This workbook should be self-contained. My initial thought was to import the forms in as graphics files and place them as background (watermark) graphics to each worksheet. It takes some fiddling to get the cells aligned with the blanks properly, which is what I don't have time to do myself. So:
1. Create an input worksheet that encompasses and consolidates all the PDF fields
2. Place images of each form in a separate worksheet in the same workbook such that the fields can be filled in cell formulas.
3. Place reference formulas in each of the field areas in the form so that the input worksheet will automatically fill in the forms.
I have uploaded forms that need to be integrated. You can export the form field for each form to get an idea of the fields for each form, which fields are consistent across forms, and create a basis for setting up the input worksheet.
50 freelanceria on tarjonnut keskimäärin 152 $ tähän työhön
Sir, I am willing to do your project and ready to start work. I will provide you a good result with accuracy. My aim is to satisfy my client by my work. Please response. Thanks
Hi there, I'm an Excel expert and can help you re-organize the contents and build up a form-fill input file as required. Look forward to hearing from you and working with you soon. Best Regards, VL