How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31306
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I have an invoices I would like to get several information

Customer Question

I have an invoices I would like to get several information and the totals for each invoice the format is different in each invoice can you take a look?
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 1 year ago.

well, if you send a sheet I can look

Customer: replied 1 year ago.

Attachment: 2015-09-16_201719_template_test_100.xlsx

Nice talking to you again. I have this invoice that I am getting crazy since the format is very difficult. can i get a formula o a vba code to identify the information attached in the sheet requested so i can modify the data.

Expert:  The-PC-Guy replied 1 year ago.

is this one single invoice or a whole bunch of different things?

Customer: replied 1 year ago.

You can work in the first invoice and I can modify the code accordingly

Expert:  The-PC-Guy replied 1 year ago.

what information are you trying to pull specifically, and are you going to be able to make sure that every single one is in the same format, with exactly the same number of rows?

Customer: replied 1 year ago.

Everyone change and the rows change as well

Expert:  The-PC-Guy replied 1 year ago.

see this is the problem, Unless there is a uniform format, I cannot write a macro or a formula that would work. You would have to manually extract the information.

I'm pretty sure you can't afford to hire me to do that.

So your best bet, is to get it all in some uniform format, then get back to me when you are ready to continue

Customer: replied 1 year ago.

The first invoice that will be the format the only change is the items they add into the invoice for that you can give a range to look for it

Expert:  The-PC-Guy replied 1 year ago.

i would need to see an example of how you want the data populated

Customer: replied 1 year ago.

Is in the second sheet that's how I export the information from a pdf document

Expert:  The-PC-Guy replied 1 year ago.

sorry, with the format it is in, I don't really have any way of dealing with the data.

I will open up the question to other experts. Perhaps one of them can think of something I didn't

Customer: replied 1 year ago.

I delete the rest of the information, probably the the macro identify letters, number and blanks in a range of rows.

Customer: replied 1 year ago.

Attachment: 2015-09-16_213736_template_test_100.xlsx

I delete the rest of the information, probably the the macro identify letters, number and blanks in a range of rows.

Customer: replied 1 year ago.

Do you know who can help me?

Expert:  Richard replied 1 year ago.

Hi there and welcome

Can you tell me please, what is it you would actually want the code to do?

Can you explain how you envision the code actually working please?

Thank you

Customer: replied 1 year ago.

I need a code to give me the description and the totals for each invoices

Expert:  Richard replied 1 year ago.

Sorry I dont understand what you mean

A code from who? Can you explain the complete process please.

Customer: replied 1 year ago.

In the attached document you will find in yellow

Attachment: 2015-09-17_165624_template_test_100.xlsx

the code needed.

In each invoice the description and charges changed every time we have a new item. so I need the code to identify that description and total for each invoice.

Expert:  Richard replied 1 year ago.

ok, ill look into this now

Customer: replied 1 year ago.

Richard in some invoices I have to identify the number of the container(Contenedor) which is in the same description items.

Expert:  Richard replied 1 year ago.

ok, I am trying to understand what is required.

Yellow is all the details, what exactly is the code? And what do you mean code needed?

Explain the entire process, the steps of what should be done.

Customer: replied 1 year ago.

Sorry for all the confusion Richard. Let me explain the information:

I export the invoices from a pdf files to excel, under the tab (INVOICE SHEET) you will have the information marked in yellow so i need to tranfer that data on a new sheet just to have a better view in excel. I will discrabide the columns under (TOTAL SHEET)



  1. INVOICE SHEET COL A1 NEED TO TRANSFER TO (TOTAL SHEET) UNDER A1 OR THE NEXT CELL IF i HAVE MORE INVOICES

  2. INVOICE SHEET COL RAN BS5 NEED TO TRANSFER TO (TOTAL SHEET) UNDER B2 OR THE NEXT CELL IF i HAVE MORE INVOICES

  3. INVOICE SHEET COL ran A19 NEED TO TRANSFER TO (TOTAL SHEET) UNDER C2 OR THE NEXT CELL IF i HAVE MORE INVOICES

  4. INVOICE SHEET COL ran A19 NEED TO TRANSFER TO (TOTAL SHEET) UNDER C4 OR THE NEXT CELL IF i HAVE MORE INVOICES


IF YOU VERIFY THE INFORMATION WHAT i TRY TO LOOK FOR IS ONLY TO EXPORT THE INFORMATION FROM THE INVOICE. PLEASE SEE THE ATTACHED FILE

Attachment: 2015-09-17_175944_template_test_100.xlsx

Expert:  Richard replied 1 year ago.

ok, so in effect, you want a macro thats going to get the detail data from the invoice and put it into a new sheet in excel correct om one line.

And you want to copy and past the data to it, click a button and it does this

Customer: replied 1 year ago.

Correct.

Expert:  Richard replied 1 year ago.

ok, this I can do, but it will be tomorrow, is this ok? as it takes some time

Customer: replied 1 year ago.

ok Richard, the one I send you is only one invoice as you can see in the attached report I have a different invoices.

Attachment: 2015-09-17_181822_book2.xlsx

Can you do a notes in the code so i can modified accordingly to obtain the same results for the rest of the invoices?

Expert:  Richard replied 1 year ago.

ok, thats a comlpetly different invoice. That will not be possible on such differences.

Can you not copy and paste them into one format some how?

Customer: replied 1 year ago.

thats will be the format for all the invoices is more than one

Expert:  Richard replied 1 year ago.

Sorry I do not understand your last message.

you mean they all have different formats?

Customer: replied 1 year ago.

Yes they have different formats. If you can help me with the first I sent you will be great and I will figure it out the rest of the invoices :)

Expert:  Richard replied 1 year ago.

got it, let me do tomorrow as I am nearly finished for the night

I comment the code clearly so it makes sense

then send to you

this ok?

Customer: replied 1 year ago.

Yes Please.

Expert:  Richard replied 1 year ago.

thanks and till then

Expert:  Richard replied 1 year ago.

ok, tried in many ways but it is just not going to happen.

The reason is even the line items are unstructured so there is no way to predict how to speerate it all, it is just too unstructured. It can never work in this way.

Do you have a PDF version of the invoice for me?, I can check it for something.

Customer: replied 1 year ago.

Attached is the PDF version for the invoice

Attachment: 2015-09-24_112235_cotecon_manzanillo_sa_de_cv.pdf

Expert:  Richard replied 1 year ago.

Thanks, ***** ***** what I suspected.

There is no structure at all within the line items, so there is no way to actually do any coding as there is no structure to code against it. It is basically one large block of Text, with no identifiers.

You cannot code to this, it is just not possible sorry.

If you would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.

Thank you