I'm using Excel 2000 to maintain a membership list containing details
such as first name, last name, address, age, gender, ethnicity etc.
This document is kept up to date on a daily basis and at the end of
each month I transfer some of the details on to a front sheet that
tracks month-by-month totals e.g.

Jan Feb Mar
GENDER
Male 150 181 168
Female 132 156 158
etc, etc

So far I've tried a couple of methods to pick up the info for the
front sheet:
1. Referring the cells on the front sheet to a total on a pivot table
held on another worksheet
2. Using the COUNTIF function

Both methods work OK but each month I have to copy the formulae into
the new month's column and then copy the previous months figures and
paste special into the previous months column as values only.
I am about to pass this spreadsheet on to someone else to maintain and
if they forget to do the "paste special" bit, then the previous
months column will display the current months figures.
I've tried recording a macro but it repeats in the same columns. I
need it to move along a column each month, is there a simple way to do
this (my knowledge of VB is zero)

Thanks for your help

Jacob Thomas