How can I create a table in Excel that has two or more headers rows. I want to keep the range as a table so I can use the built in tools such as re-sizing, totaling, formatting, etc...
I saw a table like this in another workbook, so I know it is possible. However, I cannot find a reference on how to make a table with more than one header. Does anyone know how to do this in Office 2010? I would like to know how to do this even if it is only possible in VBA.
Thanks in advance.