Excel worksheet - transferring totals to new worksheet

  • Thread starter Thread starter Lisa Glase
  • Start date Start date
L

Lisa Glase

I've created a worksheet that has some data and a total
column for the month of January. I would now like to use
that same sheet for February, clearing out the data that
is currently there, and entering the new data for Feb.
However, I would like my total column to retain the
totals from Jan. and continue to add to it the totals for
Feb. Any idea how I can do that? My total column seems
to want to start all over again when I start February's
data.
Any help would be greatly appreciated!
 
Try this with the Month names in column B for each sheet I have January in
Row 6 through December and Adjustments in Row 18, with all my figures in
columns C to O and subtotals in Columns P and Q and Total in column R on
each sheet.
Then on the Master sheet I have:
=VLOOKUP($C$1,'Sheet No1'!$B$6:$R$18,15,FALSE)
=VLOOKUP($C$1,'Sheet No1'!$B$6:$R$18,16,FALSE)
=VLOOKUP($C$1,'Sheet No1'!$B$6:$R$18,17,FALSE)
in columns C, D and E
and enter the month name in cell C1 on your Master sheet
regards John...
 
Lisa

You can't do it this way. Formulas only work on the data
in a range. Here a a few suggestions.

Insert a column Say B for totals B/Fwd. You can then copy
the totals and using Paste Special paste the values for
the previous month into the B/Fwd column then delete the
previous month's figures and start entering this months.
This is prone to errors though, You'll for get to use
Paste Special at some time.

Create A separate sheet for each month and a final sheet
for the years totals. This would contain formulas similar
to this; =SUM(Sheet1:Sheet12!B3) Then you would just copy
this formula.

If you just want monthly totals and not the data then a
macro would be better. This way though you could get a
yearly summary Jan Feb Mar etc. Someone will help you
with a macro if you decide to go that way but you will
have to give lots of detail so we know what you need.

Regards
Peter
 
Back
Top