jimrward
Well-known Member
- Joined
- Feb 24, 2003
- Messages
- 1,910
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
Looking for ideas
I currently have a large PDF file with multiple tables which I can extract using power query and process accordingly that all works fine
There are a couple of multi column tables effectively a league table that I want to extract to my master sheet
I would like to end up with an image that I can size accordingly and layer on top of the master sheet so that I don’t affect the column heights of what is there plus it will not fit in the space available if I chose the PQ extract method
Currently I open the PDF with a 3rd party PDF tool select and cut the image I require paste it into excel and size the horizontal and vertical so it fits
Ideas please on how to automate this
I currently have a large PDF file with multiple tables which I can extract using power query and process accordingly that all works fine
There are a couple of multi column tables effectively a league table that I want to extract to my master sheet
I would like to end up with an image that I can size accordingly and layer on top of the master sheet so that I don’t affect the column heights of what is there plus it will not fit in the space available if I chose the PQ extract method
Currently I open the PDF with a 3rd party PDF tool select and cut the image I require paste it into excel and size the horizontal and vertical so it fits
Ideas please on how to automate this
