G
Guest
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?
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?