dynamic link from one sheet to next

  • Thread starter Thread starter Windjamer
  • Start date Start date
W

Windjamer

I'm not a spreadsheet enthusiast, but do use Excel for bookkeeping. I want
to have the entry amount for a new month (sheet in a workbook) be the total
from the previous month. However, if I add a line item or correct a previous
entry, I don't want to have to correct the entry or link.

Presently I'm using "=+November03!G32" or "=+subtotal_nov" but have little
confidence in either. What should I be doing?

Thanks for any help.

Glen

(e-mail address removed)
"Living on Earth is expensive, but it does include a free trip around the
sun every year." Anonymous
 
If you total for column G is in g32 and you insert a row ABOVE it the
formula will adjust and you don't need the Lotus + so

=November03!G32
 
Sounds like two questions.

the first is linking dynamically to the previous sheet and the second has to
do with adjusting references.

The second should work with no problem as Don pointed out.

There is no means to dynamically link to a prevous sheet automatically. You
could put the prevous sheet name in a cell and have your formulas be dynamic

=Indirect(A1 & "!G32") (A1 holds the previous sheet name).

however, in this case, the G32 won't adjust per your first question.
 
Back
Top