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

automatically insert new row
 

use

res = application.Match(clng(datetoadd),RangeofDates,1)

to find the row in the RangeofDates range

This is the worksheetfunction Match, so see Excel Help on Match for
specifics.

--
Regards,
Tom Ogilvy



"Geoff" wrote in message
...
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