I have to create a table to present some complicate data at work.\u00a0 The different sections in the table are included or excluded depends on different configurations.\u00a0 It would be too overwhelming and confusing to write a static table and then ask the user figure out which piece of data he need on his own.\u00a0\u00a0 My solution is to write a dynamic table that will only show the necessary piece of information.\u00a0 At first I wanted to write the table using HTML and Javascript, which I am quite familiar with.\u00a0 Unfortunately, the ancient Microsoft Office 2000 at work doesn’t support embedded javascript.\u00a0 Since including seperate HTML file in the document is not a standard work flow in my company, it would be too much trouble work around the doucument control system.\u00a0 So I decided to write the table using Excel spreadsheet instead.\u00a0 I never done programming in Excel before, but to my surprise the Visual Basic support for Excel is very easy to use.\u00a0 Using just the reference in the help document and some webpages on Excel tips, I manage to create the table in just a day.\u00a0 Actually, using Excel and Visual Basic script is less programming work than using HTML and Javascript.\u00a0 It even worths my effort to learn a new programming language.<\/p>\n","protected":false},"excerpt":{"rendered":"