If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel worksheet - transferring totals to new worksheet
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! |
#2
|
|||
|
|||
Excel worksheet - transferring totals to new worksheet
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... |
#3
|
|||
|
|||
Excel worksheet - transferring totals to new worksheet
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 -----Original Message----- 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! . |
Thread Tools | |
Display Modes | |
|
|