Automatically insert a row
 

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 weekl
period. For each person, I have three rows per day where I can ente
info. This is nomrally enough but ocassionally I need more rows for
particular person.

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

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

Any help would be greatly appreciated...

Afraid that I am a bit of a novice when it comes to macros...

--
mayer
-----------------------------------------------------------------------
mayerc's Profile: http://www.excelforum.com/member.php...fo&userid=3544
View this thread: http://www.excelforum.com/showthread.php?threadid=56015