![]() ![]() p = "C:\Users\hobs0003\Dropbox\Excel\pdf\Acrobat\Copy Pall Corp Inv 2\".Dim a, e, s$, r As Range, i As Long, p$, fso As Object.Description of Incident (Full description of Incident)Īny help would be greatly appreciated! Files.I would need the following information from the PDF organized into the worksheet titled "SIRs": I've copied the data off the PDF into column A. I'm attaching a copy of the PDF where I need the raw data from (some data has been redacted/changed for confidentiality).Īnd I'm also attaching the spreadsheet of which I'm working off of. 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? 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |