View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Flipper Flipper is offline
external usenet poster
 
Posts: 51
Default macro to insert rows

Can someone please help me wrtie a macro that will insert 1 blank row between
the end of one month and the start of another? Example: I want a row
between
1/31/200 and 2/1/2000. I have a large spreadsheet I would like to do this
with. Also, if possible, I would also like a formula inserted in that blank
row that calculates the average for the month in column 2.
1/27/2000 5.69
1/28/2000 5.81
1/31/2000 5.84
2/1/2000 5.84
2/2/2000 5.88



--
Allan