Hello All, I am currently working on a spreadsheet that will paste data from specified fields within a pdf document. For example, I am interested in using VBA to extract specific data (such as name, net totals, and so on) from a pdf document into the excel spreadsheet fields. Anyone able to point me in the right direction on how to build the code in excel?

like
Posting as :
works at
You are currently posting as works at

Depending on how your pdf is structured, and assuming it's always that same template, you don't need VBA - just go to Data-> get data -> From file -> From pdf.

After that, check if your pdf is structured well enough so that excel is able to easily recognize the desired data entry

like

Yes! The pdf will be structured the same every time. I will give it a try. Thank you!

Related Posts

Hi ,

Does Atos Syntel allocate night shifts to women employees?
Atos Syntel have any development projects?

Honestly what's your thoughts on brand purpose? I have a concept that I'm presenting this week which is heavily based on a good cause but connected to the brand.

like

Hi Fishers,

What is the best time of the year to be in the notice period?

I mean what is the time of the year where requirements in most of the companies are at pick?

Like in Dec and March you will see less requirement due to Christmas and financial year ending. Similar what is the best period?

Because in my previous switch, 15 days were wasted due to Christmas and in March lot of requirements went on hold due to financial year ending.

Thanks

Could anyone recommend a set of indices that are publicly available and is a good predictor for consumer spend in home renovations ?

like

Hello Team,

GBT team inform to submit the card details for travel and hotel booking. When I am trying to submit the details getting some issue like enter your RSA securid passcode as well as help me how I can login into concure application.

like

The voice of an outlook email notification gives me anxiety. Does anyone else feel this way or know how i can calm myself? This is a new feeling

like

Any H1B sponsoring jobs for Dynamics 365 F&O functionals? Deloitte KPMG EY PwC Accenture Microsoft McKinsey & CompanyBain & Company

Hi everyone,

I have joined a company with degree background. If I do my MCA in distance mode. Will that be valid, if I want to shift to another company

What's a good place to start the research on bikes? Wife and I are not bikers but lately we have started renting bikes for weekend trips (trail/mountain bikes) Thinking of getting our own bikes but have no clue where to begin. Checked out a few youtube videos and most of them were sponsored. Looking for suggestions.

like

Got an offer for SE III at a large tech company. Product I'd be working on interests me and I think I could grow more than in my current role.

Currently I make 180k base and have ISO/RSUs @ startup (60k/yr worth on paper, but won't be worth anything for a few years, if at all).

The offer is:
Base: $166,500
Target Bonus: 10% ($16,650)
RSU: 120k total (30k/yr)

Thoughts on offer? Should I counter?

Additionally there's a yearly target RSU bonus about equal to the cash bonus. Thoughts? 4.5 YOE

like

Has anyone recently interviewing with Boeing or have joined recently? Please comment need to know about the interview process.

How long they take after project manager round?

(5 yrs Full stack)

like

Floyd modeling his business-professional wear.

Post Photo
likeupliftingfunny

Looking to transition to flutter and nextjs (react) dev roles with web2 or web3 (blockchain) as backend.Have started self study for flutter and react.

Background - Have 10 years of experience with 3 years in electronics + 3 years of overall IT + right now 4 years of jsp based web application development and project management.

Current ctc -23 lpa

Seeking any tips or guidance from the community.

Salary range of Associate Consultant in KPMG?

like

What do you or your firm do to provide first class service?

like

Can I just say I love that this sub just talks about whiskey?

likeuplifting

Since we’ve all been working from home for months now, what’s the best office chair out that y’all are using for our long work from home hours? Looking to invest in a better one than my ~$150 one from Amazon.

like

Hello everyone! I was hoping to get your help! I'm looking for volunteers that will answer some questions about the struggles teachers go through. Currently, I'm designing a program for teachers...

like

Sorry if this has been asked a few times but - relocating to Charlotte and looking for apartments, preferably in southend. Any solid recommendations or places to avoid?

Looking for a 1 BR - 2.4K a month or less.

TYSM!!

Let’s talk credit cards! Is there any one which has 0% foreign transaction fee? (Like Revolut)

like

Additional Posts in Excel Genius

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Still don't have xlookup. #fomo

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Would anyone be willing to teach me vlookup?

like

How do you fix microsoft excel cannot paste data error?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal