Inserting rows on cell trigger
 

Say I have a sheet with 5 rows (1:5) and 5 columns (A:E) where I'll be
inputting data. Is there some way to, when I insert data in cell D5,
to have Excel automatically insert a new row at A6?

Think of a sheet that has multiple (horizontal) sections where I'm
keeping track of some data. When I exceed a certain number of rows in
any particular section, I want a new one inserted in that section.

At the same time, if I happen to remove enough data to where the one
before last row ends up being empty, I want the last one removed.


--
AMK4
------------------------------------------------------------------------
AMK4's Profile: http://www.excelforum.com/member.php...o&userid=19143
View this thread: http://www.excelforum.com/showthread...hreadid=507432