Transferring the Total to new worksheet by Month

KevyK · Apr 8th, 2002, 06:05 PM

Ok..I have 10 rows and 31 columns(represents a month), each column is totalled as is each row. I would like the total at the end of the month(last column)to be transfered to wksheet 2 to the corresponding months column.
How does it know what month and how can the data remain when entering the next months data.

kinkyparamour · Apr 8th, 2002, 06:47 PM

There are a lot of ways to do what you want but I think the easiest is to use Paste Special. On the data you want to copy right click your mouse and chose Copy. Now on the sheet you want to copy to place the mouse pointer in the cell where you want the data.Again right click the mouse and chose Paste Special. On the lower left of the popup window chose Paste Link. Now the data from sheet one will appear on sheet two.....

Denny

teebruin · Apr 8th, 2002, 10:02 PM

If you will be reusing the first worksheet for the next month, then you don't want to paste link because the values on the second worksheet will change when you change the values on the first worksheet. If you want to preserve the old numbers, then you should probably do a paste special - values.

Dave Patton · Apr 8th, 2002, 10:32 PM

If you retain each month in the spreadsheet,
you can name the total amount for each month and use a formual in the summary sheet such as the following:

For January (month 1) =Total1
February(month 2) =Total2

or you can ignore the Total and sum all the detail (I named the sheets 1, 2, etc)

January =SUM('1'!A1:AE1)
February =SUM('2'!A1:AE1)

If you do not keep all the sheets in the spreadsheet, use Edit Copy and Edit Paste Special Values.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 06:05 PM	#1
KevyK New Member Join Date: Apr 2002 Posts: 1	Ok..I have 10 rows and 31 columns(represents a month), each column is totalled as is each row. I would like the total at the end of the month(last column)to be transfered to wksheet 2 to the corresponding months column. How does it know what month and how can the data remain when entering the next months data.

Apr 8th, 2002, 06:47 PM	#2
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	There are a lot of ways to do what you want but I think the easiest is to use Paste Special. On the data you want to copy right click your mouse and chose Copy. Now on the sheet you want to copy to place the mouse pointer in the cell where you want the data.Again right click the mouse and chose Paste Special. On the lower left of the popup window chose Paste Link. Now the data from sheet one will appear on sheet two..... Denny

Apr 8th, 2002, 10:02 PM	#3
teebruin New Member Join Date: Mar 2002 Posts: 38	If you will be reusing the first worksheet for the next month, then you don't want to paste link because the values on the second worksheet will change when you change the values on the first worksheet. If you want to preserve the old numbers, then you should probably do a paste special - values.

Apr 8th, 2002, 10:32 PM	#4
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	If you retain each month in the spreadsheet, you can name the total amount for each month and use a formual in the summary sheet such as the following: For January (month 1) =Total1 February(month 2) =Total2 or you can ignore the Total and sum all the detail (I named the sheets 1, 2, etc) January =SUM('1'!A1:AE1) February =SUM('2'!A1:AE1) If you do not keep all the sheets in the spreadsheet, use Edit Copy and Edit Paste Special Values.