Automatically adding a row to a list
 

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...


--
mayerc
------------------------------------------------------------------------
mayerc's Profile: http://www.excelforum.com/member.php...o&userid=35447
View this thread: http://www.excelforum.com/showthread...hreadid=559871

Automatically adding a row to a list
 

I would suggest a macro linked to the Worksheet_Change event. You could
test if the row was the last of the three, insert a new row below and
then copy/paste special formats from the original.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=559871