maygenhetherington
New Member
- Joined
- Jun 13, 2008
- Messages
- 11
I would like to import specific data from a pdf into a running excel sheet. The pdf format may differ depending on the document itself but the titles of the data I would need would remain the same. I am not an advanced excel user but have followed online instructions to a point. Here is what I have done:
data tab
get data from file > pdf
select and import file
select "page001"
transform data
At this point, I can find the data i need throughout the columns. How would I automate this as a saved query so other employees could essential run a query and excel would pull in all the necessary information and sort it into the appropriately named columns?
Thank you for any input
data tab
get data from file > pdf
select and import file
select "page001"
transform data
At this point, I can find the data i need throughout the columns. How would I automate this as a saved query so other employees could essential run a query and excel would pull in all the necessary information and sort it into the appropriately named columns?
Thank you for any input
