Hi Iffy,

I just noticed you are using Excel 2003. A new feature called "Lists" was introduced in Excel 2003 which you can use here. Basically, they're a fancied-up version of the tip Macropod gave in his last post. Here's a quick online course on how to use them:
http://office.microsoft.com/en-us/tr...001080135.aspx

Let us know if using a list solves your question?


As I said, I do like to keep my totals at the top of the sheet - it particularly suits the type of work I do in Excel. This is just my preference and is not by any means a golden rule.

Hope that helps...
Colin