Summary Sheet
 

Hi ,

I would appreciate your help with the following.

I have a spreadsheet with a "summary" sheet with
following "headings" in the range B5 to B8.

Visits
New Contacts added
Jobs On
Filled

In columns C to D on the Summary Sheet are totals for the number of "visits"
etc. The totals are from data contained in all worksheets except "Summary" .
At every instance of "visits" the data contained in next 2 columns is
"added". "Visits" is in column B in the worksheets and data in column C and D
is to be summed.

Same procedure is to be follwed for the rest of the headings.

The problem is that the number of worksheets varies month on month and
occurrence of the above 4 words also varies on each sheet.

Thanks


The number of sheets after "summary" varies each month.

I am interested in the value in the next column 2 columns after the
word "visit". All values need to be "totalled" and the cumulative
total should appear in the "summary" sheet in columns C & D.Next
to "Visits"

Once total for "Visits" has completed the macro should do likewise
for the rest of the "headings" in the above list