Macro to extract certain numbers following strings (sample attached)

[tisahardknocklife]

Hi all,

I need some help with a macro that can identify the numbers following a string and export it to corresponding columns.

There are some catches, though, that make it more complicated.
It is hard to explain all the niches with words, so i've created and attached a sample doc for what I'm looking for.


Any and all help is appreciated!
Thanks!

[jindon]

Please Login or Register  to view this content.

[tisahardknocklife]

Forgive me for asking, but this all looks like gibberish to me haha.

How do I specify things like "Amazon" and "Google" in the macro?

[jindon]

Have tried the code?

[tisahardknocklife]

@jindon

My "Google" values weren't showing up, but I figured out what was going wrong, in the text the string "Google :" was written instead of "Google: ".

There's just one other thing though----decimals are being truncated when the macro is run.
e.g. Amazon "5.444" is cut down to "5"

How do I change it to make all decimal points show up?

[jindon]

OOps, sorry, I didn't notice that...
Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[tisahardknocklife]

Hmm, that didn't seem to solve the issue.

I also checked the cell formatting to make sure the decimals weren't just being hidden--they're showing up as __.00000

[jindon]

That one,too...

Please Login or Register  to view this content.

[tisahardknocklife]

@jindon

This sub works great, though I should have mentioned that sometimes I will have negative values, under say, Amazon.

This macro doesn't seem to pick those up. How can I modify it to get those?

Thanks!

[jindon]

Change .Pattern to

Please Login or Register  to view this content.