I absolutely agree. And while I hate VBA, it makes excel that much more powerful. It even makes up for some of the bugs in excel such as absolute references fro

I absolutely agree. And while I hate VBA, it makes excel that much more powerful. It even makes up for some of the bugs in excel such as absolute references from a different workbook doesn't transpose using the built in transpose function. However, using the built in copy / paste formula functionality, it works fine. In this case, a simple macro which takes 5 mins to write will resolve this otherwise annoying bug. Although the most annoying thing about Excel is actually the users who insist on using it like a database...