OK, time for some non Excel 2007 stuff…
Recently someone asked me if it was possible to transpose a table of cells, but in such a way that the formula of each cell is kept intact. I decided VBA was the way to go and produced a small but very useful little routine for that.
What the poster wanted is to go from:
Read on here.
Jan Karel Pieterse
Founding member of:
Professional Office Developers Association