Excel Hacks

Credits

About the Authors

David and Raina Hawley provide business applications, training and tutoring in all aspects of Excel and VBA for Excel through OzGrid Business Applications in Western Australia.

David Hawley has spent the last 12 years creating business applications using Excel and VBA for Excel on a day-to-day basis. He produces a monthly newsletter containing information on the use of Excel and VBA for Excel. He runs and maintains a popular Excel forum on the OzGrid site.

Raina Hawley lectures in industry and in the college education system, and is a registered workplace assessor. Raina runs the OzGrid office and administration side of the business, and works in Excel solutions alongside her husband. They offer hundreds of Excel Add-Ins and business software designed for data analysis in all industry areas through their web site at http://www.ozgrid.com. They live in Bunbury, Western Australia with their two children.

Contributors

The following people contributed their hacks, writing, and inspiration to this book:

• Andy Pope started working for Digitab in 1986 as a junior programmer, mostly using Fortran. Digitab is a data-processing bureau situated in London. Andy now deals with all IT issues for Digitab and has installed the companies network infrastructure, purchased IT hardware and software, installed and maintained mainframes, mini-frames, servers, and desktop PC’s, and now also provides support to users with both software and hardware support. He currently writes customized solutions for reporting projects, using Office and VBA. He has his own web site at http://www.andypope.info/.

• Paul Bausch is an accomplished Web Application Developer and is a cocreator of the popular weblog software Blogger (see http://www.blogger.com/). He cowrote We Blog: Publishing Online with Weblogs (John Wiley & Sons), and posts thoughts and photos almost daily to his personal weblog, onfocus (http://www.onfocus.com/).

• Simon St.Laurent is an Editor with O’Reilly and Associates, Inc. Prior to that, he’d been a web developer, network administrator, computer book author, and XML troublemaker. He lives in Dryden, NY. His books include XML: A Primer, and XML Elements of Style. He is a contributing editor to xmlhack (http://www.xmlhack.com) and an occasional contributor to XML.com (http://www.xml.com). For more information about Simon’s books and projects, see http://simonstl.com.

Acknowledgments

First and foremost, we would like to thank our parents, Walter and Beryl Fenlon and Mike and Marlene Hawley, for without their love and support, we never would have made it through.

Thanks must also go to John Read, who gave us great guidance along the way, and to the team at O’Reilly, especially Simon, for all the hard work that has been put into this book. Andy Pope must be thanked also for the hacks he contributed, and we have to mention all the visitors to our web site and forum, who helped us identify some of the most common issues that people face.

Finally, we must thank Aleisha and Kate, as always, our inspiration. Their understanding and extra efforts to be good while the book was in progress will be remembered!!