An Excel Helper's Cheat Sheet

[taurean]

this is insanely close to what i was referring to thank you. just wish it was organized in categories, but beggars cant be choosers.

Also there is famous Hiker's list on MrExcel which I remembered later.

Splitting Single Column Data Into Three

Hi All! I am having data in a single column ..nearly 10,000 cells.. column A 1 FLOWERS ROSE JASMIN TULIP 2 DOGS BULLDOG GERMANSHEPHERED I Would like to split this data AS Column A Column B Column C 1 FLOWERS ROSE 1 FLOWERS JASMIN 1...

www.mrexcel.com

@mikerickson As I understood this post is for helper for quick search and not for end users per se. I might be wrong!

 

[DataBlake]

@mikerickson As I understood this post is for helper for quick search and not for end users per se. I might be wrong!

correct!
I understand end users will be end users. I just want a quick and easy way to navigate useful info to share, templates, and formula basics.
What you've supplied is SO GOOD. i love it thank you.

 

[CephasOz]

In the same vein, but for personal use, I have a lot of reusable code stored in a "The Guide" file. The Guide uses outlining, so I can keep my code in a structured fashion. (For example, I have a node called "Sort", with a variety of different sort functions as its child nodes.) Whenever I want a piece of code to do something, I open The Guide, and using the structure can usually go straight to the code, copy, paste, and done! Sometimes, when a piece of code can be stored in several different places in The Guide, and I am looking in the wrong place, I just use Ctrl-Shift-F to find what I'm looking for. And because there is a portable version - see The Guide Portable (two-pane outliner) | PortableApps.com - I can load it onto a USB stick and use it on any computer. The only complaint I have with The Guide is that it doesn't understand VBA, so everything is mono-coloured text. (The Guide will also store entire files and graphics, not just text, if you need that.)

A side-effect of doing things this way is I only paste the code that I actually use into a given project. Before I used to wholesale import modules, because 60% of the code in a given module might be used. Now I just compile, and when it complains that a sub/function isn't present, I copy and paste, then repeat the compile to pick up the next one, until there are none missing. Only the necessary code is then present.

 

[DataBlake]

In the same vein, but for personal use, I have a lot of reusable code stored in a "The Guide" file. The Guide uses outlining, so I can keep my code in a structured fashion. (For example, I have a node called "Sort", with a variety of different sort functions as its child nodes.)

Thats a super interesting way to keep organized. Its pretty much the same concept only mine wouldn't be for personal use. I am still working on my helper workbook, but once i'm finished with it i will share.
My version of this emphasizes ease of access to code and automatically copies templates to your clipboard after making a selection, I've even been considering writing entire responses to the most generic questions like "multiple criteria vlookup" and match/index type of things as they are one in the same, just pointing to different columns. I also happen to be a fan of teaching someone how to do things as opposed to just giving them a solution (even though most of the time i just give them the solution)