Bank statement conversion macro

Bank string and expected results

Pick the number from 1st date debit it if negative and credit it if positive

I have 80 pages and i am just on page typing one by one , not sure when i will finish this , if only you can pull me the numerics , it will do too without dates

Can someone handle this as text to column not works

Please Login or Register  to view this content.

Thank you so much , u saved my day

If i get this today i shall be so glad , anyone please

Jindon wow the pattern in your macro

Thank you so very much again Jindon , yet another saved day

The macro not runs , Jindon what should it be

Tested one one whole page of the total 1oo pages i have

Jindon , the text pulling looks complicated , if i can only pull figures enough for now
If It can do everything more cooler

Because the string in A1 is completely different from the one before.

Fnd attached this only will do , seems the bank hides the withdrawal amounts , i will manually plug them

Dates and Deposits only rest I will finish , the date itself will save me a huge time

07-01-16 000611 MANSOOR INDUSTRIES LTD

That is what is it does , it hides the amount spent , thus date only will and amount of when cash deposit