View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff Geoff is offline
external usenet poster
 
Posts: 371
Default automatically insert new row

my database manages service calls, it already add six months to a Service
date.What i need it to do is copy the information from that row and paste it
to a new row (based on the date) which may be between other rows already
present ie.

Date Serviced Company Next Ser Date
10/02/05 acme Ltd 10/08/05

Database:

Date Due Company
09/08/05 Collus Ltd
11/08/05 Dillo Ltd

Please help