Learn How To Use Macros!

ThatSwissIMGuy

New member
Jun 17, 2009
626
3
0
Lulz at me just now figuring out how awesome Macros actually are.

Was just building a keyword list and so far most of the formatting, copy and pasting etc. bullshit I've done by hand but now I just realized how Macros will do all that shit for me.

One evening spent figuring them out, hours and hours saved in the futur for sure!

I thought as I hadn't realized how great they really are yet, I figured there should at least be another one or two dumb asses out there that don't know either so a thread was needed.
 


Wow, just Wow, this is Wow, and like awesome and stuff!

Rage9 has thanked you.
 
Lulz at me just now figuring out how awesome Macros actually are.

Was just building a keyword list and so far most of the formatting, copy and pasting etc. bullshit I've done by hand but now I just realized how Macros will do all that shit for me.

One evening spent figuring them out, hours and hours saved in the futur for sure!

I thought as I hadn't realized how great they really are yet, I figured there should at least be another one or two dumb asses out there that don't know either so a thread was needed.

Elaborate please...
 
are you talking about excel macros or something like imacros? i've never learned macros in excel.
 
I'm talking about excel Macros

Quite simple:

I use google related terms a lot for initial keyword research.

If you've ever done it, you know that the copy and paste has a pain-in-the-ass formatting.

What my macro does is:

First, remove all not needed carracters (like the numbering)
Second, put it all nice in a row without spaces (even if you delet some of them)
Third, move it automatically down the column
Fourth, mark the keywords that exist multiple times

Sounds like it really isn't much it does, but for the fact that I was able to do it myself (instead of having my programmer write an actuall program), it works great.

If anybody wants it, I'll gladly share.
 
I can't upload it here as it doesn't accept .xlsm so just send me a PM with your e-mail and I'll send it to you.

Make sure you have Macros enabled (gotta do that somewhere in properties) otherwise it won't do anything.