I had the same question. It was not possible to solve the problem using macros. A very close solution was obtained by using slices, in excel itself support.microsoft.com