How can I copy column sums to another spreadsheets as numbers
 

Using a workbook with income/expense worksheets for each month I would like
to copy and paste the column totals for each month into a yearly summary
worksheet - but, of course, these cells are results of formulas, so I get a
#REF error when they are copied to a new worksheet. Is there any way I can
convert the cell contents to the actual figures that are displayed in the
cell? Thanks.

Aunt Pat

Have a look in vba HELP for PASTESPECIAL

--
Don Guillett
SalesAid Software

"auntpat" wrote in message
...
Using a workbook with income/expense worksheets for each month I would
like
to copy and paste the column totals for each month into a yearly summary
worksheet - but, of course, these cells are results of formulas, so I get
a
#REF error when they are copied to a new worksheet. Is there any way I
can
convert the cell contents to the actual figures that are displayed in the
cell? Thanks.

Aunt Pat

Thanks, Don. I did search help, but none of the search terms I could think
of pointed me to the answer.

"Don Guillett" wrote:

Have a look in vba HELP for PASTESPECIAL

--
Don Guillett
SalesAid Software

"auntpat" wrote in message
...
Using a workbook with income/expense worksheets for each month I would
like
to copy and paste the column totals for each month into a yearly summary
worksheet - but, of course, these cells are results of formulas, so I get
a
#REF error when they are copied to a new worksheet. Is there any way I
can
convert the cell contents to the actual figures that are displayed in the
cell? Thanks.

Aunt Pat

auntpat

Don assumed you would use VBA code to do the copy/pastespecial.

If you do it manually........

Copy the column totals and Paste SpecialValuesOKEsc.

Maybe also look at "linking" these cells back to the monthly totals cells.

e.g. on yearly sheet in A1 enter =January!A56 where A56 is the total for
January.

Gord Dibben Excel MVP

On Mon, 3 Jan 2005 09:41:01 -0800, "auntpat"
wrote:

Thanks, Don. I did search help, but none of the search terms I could think
of pointed me to the answer.

"Don Guillett" wrote:

Have a look in vba HELP for PASTESPECIAL

--
Don Guillett
SalesAid Software

"auntpat" wrote in message
...
Using a workbook with income/expense worksheets for each month I would
like
to copy and paste the column totals for each month into a yearly summary
worksheet - but, of course, these cells are results of formulas, so I get
a
#REF error when they are copied to a new worksheet. Is there any way I
can
convert the cell contents to the actual figures that are displayed in the
cell? Thanks.

Aunt Pat