Posted by ethan66 on 9/14/2011 10:29:00 AM (view original):
Posted by zsap on 9/11/2011 7:21:00 PM (view original):
Just found this in the forums and I don't know how to make macros and I would love it to make this process easier, any advice on how to implement a macro into my excel spreadsheet?
There is a macro recorder built into Excel that will actually record your keystrokes for the simple stuff. I use that to alter my recruits list according to potential (but haven't gone to the trouble of using potential as part of a ranking formula).
If you want to get more complicated than the macro recorder, you'll need to be able to use Excel's VBA language. One of the real beauties of Excel these days (compared to when I first learned 1-2-3 back in the '80s) is that everything you need to know is available on the internet for free. The number of tutorials out there is mind-boggling.
Yeah that is true, VBA isn't a very difficult language once you get the hang of it either. I haven't ever really used spreadsheets for HD but it could be useful to those that are interested in using them.