This is a Proof of Concept project. This project is to build a prototype for a process that if proven, will lead to a much larger project that the freelancer will be allowed to submit a bid on. Step one in the process will be to export data from a Fillable pdf that is already populated, into an Excel spreadsheet. The information from the pdf will need to be mapped to identified locations within Excel. The second step will be that after I make manual changes to the data in Excel, the updated data will be exported into fields in a different Fillable pdf form.
I am only interested in using Excel and Adobe Acrobat. No other options will be considered.
Attached is a sample pdf form with the fields populated. Also attached is an Excel spreadsheet that has the field locations identified for mapping purposes. A final blank Fillable pdf is provided for the output.
Further instructions are:
1. Transfer the information in the populated pdf we have provided to the fields in the Excel spreadsheet that are marked in blue.
2. The adjustments that we would make are already made for demonstration purposes.
3. Using the data in the Excel spreadsheet that has been updated with our manual adjustments (marked with green cells), populate the final Fillable pdf and fill in the appropriate blanks.
4. Both of the sequences (first one being the transfer of data into Excel and the second one being the transfer of data out of Excel) need to have a button installed so that the transfer can be executed.
Please remember that this is a ‘Proof of Concept’ project only. Once the solution is proven and acceptable, the successful bidder will be allowed to bid on a larger project that will include many different pdf forms being mapped to a number of Excel spreadsheets.