Learning Excel VBA as well as complicated formula like IF,LookUP

[don1235]

Dear Sir,

Coming from a complete non-programmer background, I am interested in picking this 2 skills for manipulation of data. However, even after buying books such as Excel VBA for dummies, MR Excel etc, I still have great difficulty understanding. This may be due to my background and also an utter lack of problem to solve using VBA as well as the nestled functions. Is there any suggestions like you can do to pick up the skill.....

 

[VoG]

Take a look at Hiker's List http://www.mrexcel.com/forum/showpost.php?p=2676997&postcount=5

 

[don1235]

Some are useful while quite a few of the links are broken

 

[sous2817]

For me, the best way to learn is come up with a realistic, if not actual problem, and post questions here and ask specific questions that you have. Not "hey, can someone automate this for me" but "given this data layout, how do I sum all columns that have at least {X} number of widgets" or whatever your problem is.

 

[don1235]

Any sites to recommend that give problems......

 

[SuperFerret]

Any sites to recommend that give problems......

Here ?

Seriously though, I've only got to where I am through sitting on here