Need to learn how to write VBA code?

I recently started a new job and found myself being bogged down by manual validation. 

Time to work smarter.

If you find yourself spending too much time doing small admin task like manual validation in excel spreadsheets, you need to learn how to work smarter. 4 hours of working on a code will save you days of manual work. You don’t need to do a course, you don’t need to outsource to an IT company. I’ve written copied countless VBA macros. When I started I had absolutely no idea what half of the code means, VBA is not my expertise. I’m an engineer by education and an energy pricing/trading specialist by employment. Combine these two areas and we get validation automation. I’ve taken back those hours of manual work and I can now focus on deep pricing/trading analysis, and risk mitigation. 

Steps to automate your manual excel processes: 

Step 1: Plan it out, think how you would want your macro to work. 

Step 2: Open a search engine of your choice.

Step 3: Search for the code you want, e.g “VBA code for multiple goal seek” ... I found a youtube video - https://www.youtube.com/watch?v=NsYvERSCAfU

Step 4: Copy the code.

Step 5: Open Module of spreadsheet .

Step 6: Paste code/Type code out word for word (not ideal but YT video didn't provide the code)

Make sure the code you’re taking is opened and closed. That is, it starts with “Sub” and ends with “End Sub”. There are thousands of people online with excel blogs or vlogs, YouTube is a great place to look also. 

If I can do it, anyone can. 

If you found this helpful, let me know. 

Disclaimer: If you need a complex code written I would definitely look for help from an expert. YouTube and google will only help to a certain level. I'm happy to help point you in the right direction, just ask!

Emmet Higgins