View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Capsaisin
 
Posts: n/a
Default Auto insert new row after current row filled in

HI

I am creating a workbook that has a column for the name of the bill, a colum
for the ammount of the bill, and at the bottom of the ammount colum, a total.

I would like it to be so that every time i fill in the last row before the
total, a new row is generated so that i dont have to keep doing it manually.

for example:

electric 10
phone 21
cell 13
44
becomes

electric 10
phone 21
cell 13

44



Thank you