Hello - I recently received help in creating a macro that takes data from a worksheet with raw data and organizes it into another worksheet in specific rows & columns. I'm wondering if I can take this a step further by perhaps copying directly off the PDF and pasting it into the "Raw" worksheet and then run a macro/VBA code that would organize specific data into specific rows on another worksheet (SIRs) and placing it in the next empty cell?
I'm attaching a copy of the PDF where I need the raw data from (some data has been redacted/changed for confidentiality).
And I'm also attaching the spreadsheet of which I'm working off of. I've copied the data off the PDF into column A.
I would need the following information from the PDF organized into the worksheet titled "SIRs":
- Name of the Program
- Event ID
- First Name(s)
- Last Name(s)
- Date Reported to Care Provider
- Time Reported to Care Provider
- Description of Incident (Full description of Incident)
- Gender
- Child's Country of Birth
- Age
- LOS
Any help would be greatly appreciated!