I tried to use the XL2BB but it doesn't seem to be working for me on my work computer. So I am inputting an image into this thread and attaching a link to the spreadsheet on my google drive. So there are some crazy security permissions on these PDF forms we get, I could not print to PDF to try to discover the form fields and export the data, it kept giving me an error. I also cant open the PDF as a word document, when I export it to excel it looks even worse than this but exporting to .xml seems the cleanest way to go. I am open to more suggestions regarding getting this from PDF into Excel.
So I can deal with 20-30 of these a day, I have to take what is in the field and input it into a spreadsheet, there could be anywhere from 1 product to 2 products I just cut it off at 2. The labels will always be the same but the data included in the form fields will always change. and usually more than what I did to it to randomize the data. In the image below the left side shows what the form looks like when exported to XML, ant the right side shows how I would like to display the data, I might also prefer to put the product #2 and so on directly under Product #1 rather than give it its own column only because the rest of the form is specific to just that entire order this is the only section specific to Product #
So if you have any suggestions on where I can begin, or if you have seen something like this before this would be a huge time saver!
I am pretty decent with formulas but I am awful at writing VBA outside of the "Record Macro" function. And as found with the XL2BB it appears my work has locked down the ability for me to use any add-ons.
Here is a link to Editable Version the spreadsheet on my GoogleDrive. Here is a link to View Only the file in case anyone messes it up.
Huge thank you to anyone who provides assistance!
So I can deal with 20-30 of these a day, I have to take what is in the field and input it into a spreadsheet, there could be anywhere from 1 product to 2 products I just cut it off at 2. The labels will always be the same but the data included in the form fields will always change. and usually more than what I did to it to randomize the data. In the image below the left side shows what the form looks like when exported to XML, ant the right side shows how I would like to display the data, I might also prefer to put the product #2 and so on directly under Product #1 rather than give it its own column only because the rest of the form is specific to just that entire order this is the only section specific to Product #
So if you have any suggestions on where I can begin, or if you have seen something like this before this would be a huge time saver!
I am pretty decent with formulas but I am awful at writing VBA outside of the "Record Macro" function. And as found with the XL2BB it appears my work has locked down the ability for me to use any add-ons.
Here is a link to Editable Version the spreadsheet on my GoogleDrive. Here is a link to View Only the file in case anyone messes it up.
Huge thank you to anyone who provides assistance!
