Okay, here goes:
I have converted 1092 PDF pages (purchase orders) into an Excel database. Because of the layout of the PDF it does not quite translate into a proper table for the various column needs.
In an effort to pull just the specific information I need from each purchase order I will need to:
1. Search the entire worksheet for anytime a specific word is found; for example "Total"
2. Return the vlaue from an Offset cell with that specific word "Total"
3. Have each of these values in their own column so I can obtain a Grand Total.
Sounds like it should be easy in theory but, I am fast learning how much of a novice I really am. Any suggestions or solutions would be greatly appreciated.
Bookmarks