Hi

I am using Excel 2002 and I am having a problem.

I have a large form where I enter data against people over a weekly period. For each person, I have three rows per day where I can enter info. This is nomrally enough but ocassionally I need more rows for a particular person.

What I would like happen is that when I type in the final row for that person, for another row to automatically insert itself below the row I am typing into. I have looked and I think there is a built in function to do this in version 2003 but not 2002.

To be ultra fuzzy it would be even better if the row that is automatically inserted kept the same format as the row above it. This is becuase some of the columns have merged cells and some do not.

Any help would be greatly appreciated...