
Highlight PDF text and query the column it will be entered in Excel form
- or -
Post a project like this4474
$300
- Posted:
- Proposals: 2
- Remote
- #333083
- Awarded
Description
Experience Level: Expert
Estimated project duration: 3
Highlight PDF text and query the column it will be entered in Excel spreadsheet. Select one phrase in PDF document and each time the matching phrase is found in the PDF document colocate the phrase in Excel spreadsheet in a row and column that is initially queried. The Excel spreadsheet is a pre-existing file (template file). The data is entered into the row & column queried and does not interrupt with other data on the Excel template file. This allows for PDF data to be captured and entered into a Excel template file which is really a form. But the Excel form is only one (1) sheet and therefore as the data is transferred from the PDF document into this for additional mirror image pages of this form will be automatically created and allow for more data to be entered. Each time a new Excel page is create the page is automatically numbered at bottom center as page 1, 2, 3...x
When "RUN" is selected all same instances of matching phrase will all add to the subsequent cell in the defined column (the next cell could be a column or row). Multiple PDF pages can be "RUN" at one time as long as in the same file. Each time the selected phrase in the PDF document is transferred to Excel the phrase is automatically crossed out in the PDF document. This allows the user to see which phrases have been transferred to Excel spreadsheet.
For example, the phrase "Manual Pull Station" is highlighted in the PDf document the program will query which row & column to enter this data in the selected Excel form. Note that there is other data associated with the above phrase, such as, a description of what floor and other location information. This data must be transferred along with the original phrase to corresponding and defined row & column. Multiple columns may have to be associated with the original phrase and defined as to where they are placed in the Excel form.
I have attached two PDF files that I will want to put the data, as defined, into the Excel form attached.
More clarification can be provided once a candidate is selected for the job.
When "RUN" is selected all same instances of matching phrase will all add to the subsequent cell in the defined column (the next cell could be a column or row). Multiple PDF pages can be "RUN" at one time as long as in the same file. Each time the selected phrase in the PDF document is transferred to Excel the phrase is automatically crossed out in the PDF document. This allows the user to see which phrases have been transferred to Excel spreadsheet.
For example, the phrase "Manual Pull Station" is highlighted in the PDf document the program will query which row & column to enter this data in the selected Excel form. Note that there is other data associated with the above phrase, such as, a description of what floor and other location information. This data must be transferred along with the original phrase to corresponding and defined row & column. Multiple columns may have to be associated with the original phrase and defined as to where they are placed in the Excel form.
I have attached two PDF files that I will want to put the data, as defined, into the Excel form attached.
More clarification can be provided once a candidate is selected for the job.
Rafael A.
100% (50)Projects Completed
59
Freelancers worked with
41
Projects awarded
23%
Last project
3 Feb 2023
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies