Microsoft Office Questions? Ask a IT Expert for Support ASAP
well, if you send a sheet I can look
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.
is this one single invoice or a whole bunch of different things?
You can work in the first invoice and I can modify the code accordingly
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?
Everyone change and the rows change as well
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
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
i would need to see an example of how you want the data populated
Is in the second sheet that's how I export the information from a pdf document
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
I delete the rest of the information, probably the the macro identify letters, number and blanks in a range of rows.
Do you know who can help me?
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?
I need a code to give me the description and the totals for each invoices
Sorry I dont understand what you mean
A code from who? Can you explain the complete process please.
In the attached document you will find in yellow
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.
ok, ill look into this now
Richard in some invoices I have to identify the number of the container(Contenedor) which is in the same description items.
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.
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)
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
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
ok, this I can do, but it will be tomorrow, is this ok? as it takes some time
ok Richard, the one I send you is only one invoice as you can see in the attached report I have a different invoices.
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?
thats will be the format for all the invoices is more than one
Sorry I do not understand your last message.
you mean they all have different formats?
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 :)
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
thanks and till then
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.
Attached is the PDF version for the invoice
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.