Im sorry I didnt do a good job of describing my project. First of all, you
must understand this is only the second time I have attempted to include
macros in my work. The first was when Gord helped me with this project when
I asked for help on 2 Nov 2007 in €œAuto fill multiple worksheets€�. His help
at that time did the trick, and I am now able to handle that.

The application I have designed is an effort to assist local law enforcement
by senior volunteers accomplishing daily vacation house checks while the
residents are away. We are replacing a paper system with a laptop to record
the daily activity including the time and identity of the volunteer officers
making the check. Each sheet tab name is the address of the property to be
checked. The sheets contain information providing the name of the property
owner, telephone contacts, authorized contacts, and other information. All
of this information is protected against accidental revision. The
application is set up to be run on bi-weekly periods, so the information can
be transferred to a permanent record on the citys computer. As you can
imagine, the addresses change as the residents come and go. The sheets are
arranged in the order the checks are to be made, so it is necessary to insert
new sheets (addresses) as the route order changes.

The worksheet index is an attempt to visualize all the addresses on a single
sheet, probably at the beginning of the workbook. By using the €˜count
function on the sheet added by Gords macro, the number of addresses can be
determined. The number of properties checked each day is used in our monthly
and annual report to the city.

I really appreciate the help of you fellows and the learning experience I
have gained through that help. This is a great service! If additional
details are needed to clarify the project, please contact me.

Wally


"Otto Moehrbach" wrote:

Wally
I agree with Gord. You didn't give us any information regarding what sheets
go with what route and what customers go with what route and how such could
be determined. Also define what you call an "index of the worksheets".
Imagine that you are doing this by hand, then give us a step by step of what
you do. HTH Otto
"wally" wrote in message
...
I have developed a workbook, used as a route list, containing as many as 50
to 60 worksheets. Each of the worksheets has customer details and
delivery
information including time of delivery, which can change from day to day
as
customers are added or removed. In order to complete the workbook, an
index
of the worksheets is needed. As an example, the first worksheet would
contain a list of the tabs used to complete the route, and provide the
total
of the tabs serviced on the route. Any help would be appreciated.
Thanks.

Wally