I've moved this topic to the Excel forum instead of the general feedback forum. I don't know if the solution involves VBA (it might) but this is a more appropriate forum to get the right answer, even if it isn't the perfect match.
Senior Acquisitions Editor
Wiley Technology Publishing
Jim's Book of the week: ASP.NET 2.0 Beta Preview