Carrying From Worksheet to Worksheet

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

In Excel 2002 (10.4524.4219) SP-2, I have designed a worksheet based
on IRS form Schedule D-1 to report capital gains. Because I have more
than one sheet in the file, I would like to devise a formula that
carries a total from one sheet to the next. Specifically, I would like
cell F34 on any given sheet to be a running total of the figures in
cells F8 through F31 on that sheet (which is easy enough to
accomplish) PLUS (and here's where I'm stuck) the totals of cells F8
through F31 on all the previous sheets (or, the same thing said
differently, plus the figure in cell F34 on every previous sheet in
the series). When it's done, cell F34 on the last sheet will be the
total of cells F8 through F31 on every sheet in the series, which
should be the same thing as the total of every cell F34 in every
worksheet. I hope I have made myself clear! Thanks. Peter
 
Peter

Sounds like you need to make each sheet's total equal to the total of the
items on that page, plus the total on the prior sheet.

Sheet one total

SUM(F8:f34)

Sheet two total

Sheet1 total +SUM(F8:F34)

Sheet 3 total

Sheet 2 total +SUM(F8:F34)

and so on....


HTH

PC
 
Peter,

Just a thought. I'm not sure of the IRS rules on the issue (they probably
have a whole book on the subject) but it may be worthwhile to include a
sub-total of the items on each page and a running total.

PC
 
Thank you for all your replies. For future readers who may be
interested, here is what I have done working from the suggestions
posted in response to my initial question. On every sheet, the formula
for cell F34 is =SUM(F8:F31). Then, I created a new, additional cell
F35 for which the formula is ='Sheet X'!F35+F34 where X is the number
of the immediately preceding sheet; so that, say on sheet 5, the
formula for cell F35 is ='Sheet 4'!F35+F34 (except on sheet 1, of
course, for which there is no preceder, and so the formula for F35 on
sheet 1 is simply =F34). That way, on every sheet, cell F35 equals the
totals of all the preceding cells F34 plus cell F34 in the current
sheet.
To the suggestion, "it may be worthwhile to include a sub-total
of the items on each page and a running total", I have copied the form
Schedule D-1 right off the IRS site into Excel, and of course I do not
dare alter a single comma! As it happens, the form does provide for a
sub-total of the items on each sheet, and that is cell F34. However,
there is no provision on the form for a running total (the final total
is entered on Schedule D). My new cell F35 gives me a running total,
but it appears on the sheet "below" the form, and so, in April, it
will be outside the "print area".
Anyway, thanks again to all!
 
AFAIK the IRS will accept an attachment in varying formats with the total on
the IRS form and a notation "SEE ATTACHMENT"
 
Back
Top