adding a value to existing code

[bnwash]

with great assistance from Humdingaling I was able to get code which allowed for a search of Name, Inv No and date
e.g. Tom - 12121212 - 12-5-15
The code follows:-

Now what I would like to add is a further bit that of Value
e.g.
Tom - 12121212 - 12-5-15 - $ 45.00

Now can I get assistance to add to the above code to make this happen or is it not possible
Currently the
Name is in Col B
Invoice in C
Date in D
and the Hyperlink in Col e
The Hyperlink will need to be shifted across one col to accomodate the Value
Thanks in anticipation

[Evolta]

Do you maybe have a sample sheet? That would make it easier to understand the problem and help out

Ignore my question for a sample sheet... coz it would need a sample filled directory xD
how are the PDF files named?

[bnwash]

I have added the example
This need to be in a folder with pdf files to work

[Evolta]

I think I understand how it works,.. but I assume that the files you are looking for have a certain format?

[bnwash]

Yes
The format is

Ted - 1212121212 - 12-5-15
Bill - 333333333 - 13-5-15

and I am wanting to add

Ted - 1212121212 - 12-5-15 - $ 45.00
Bill - 333333333 - 13-5-15 - $ 23.00

[Evolta]

Give this a try
Search PDF_2.xlsm

[bnwash]

That's working fine except I am getting a - directly after the date
e.g. 12-5-15-

[bnwash]

Sorry what I am getting is 12-5-15 -
there is a space after the date and the -

[Evolta]

Try replacing this line:

Please Login or Register  to view this content.

With this one:

Please Login or Register  to view this content.

[bnwash]

Sorry, but I am still getting the:- 3-6-15 -
Meaning the dash after the date.
All else is fine

[Evolta]

Ah, it worked fine on my examplefile.

try this:

Please Login or Register  to view this content.

If this is not working, please send me the full name of a pdf file (replace real names and other sensitive data with fake information)

[bnwash]

API - 145981 - 12-5-15 - $ 45.00.pdf
API - 145983 - 13-5-15 - $ 5,623.00.pdf
TIP - 36987412 - 15-5-15 - $ 908.00.pdf
Round Can - 56841478 - 16-5-15 - $ 10,000.pdf

Hope that helps

[bnwash]

If it helps the - appears only if the search is done by date
If the search is by Invoice number the date appears correctly

[Evolta]

I'm trying to understand why, but I cannot find it. It works fine for me

[bnwash]

When I search by date I get all the fields but with the date it is shown as 12-5-15 -
its the dash on the end that is the problem

[Evolta]

Hopefully the " -" are now gone.
Search PDF_2.xlsm

[bnwash]

Many thanks that did the trick
Appreciate your assistance and patience
Regards