I am trying to setup a budget book in Excel 2000. There is a schedule sheet
to set budgeted values, twelve sheets for months, and one sheet for a yearly
summary.

My problem is as follows:

Each monthly sheet has totals for different budget categories which are to
be transferred to the yearly summary sheet.

The cell values to be transferred are of the nature -
January!AE7, January!AE8 ..... January!AE32
February!AE7, February!AE8......February!AE32
. . .
. . .
December!AE7, December!AE8.....December!AE32

In the yearly summary if I try to auto fill a row by typing in two cell
values such as January!AE 7, January!AE8, highlighting the two cells, and
dragging I get-
January!AG7, January!AH7, etc which is wrong.

If I try to auto fill a colum by typing in two cell values such as
January!AE7
February!AE7
highlighting the two cells, and dragging I get-

January!AE9
February!AE9, etc which is also wrong.

I tried using Edit, Fill, Series and also Tools, Options, Custom Series to
set up a proper autofill series but nothing works. Is there a way to do what
I am attempting?

--
Frustrated Accountant (or am I an engineer? - I can''t remember anymore)