How do you move cells with a formula
 

I have a sheet with a column of numbers and there are groups that are added
to get a sum of that group. I want to transfer just the cell with the total
to the next column over. The "total" cells are the only cells that contain
formulas in the column - I can get it to find them but not move them. I have
tried IF/THEN functions but can't get figure out the wording for "if this
cell is a formula, copy the value into the next column".

How do you move cells with a formula
 

Hi Don,

You could use a user defined function like HasFormula
=IF(personal.xls!HasFormula(A2), A2,"")

see Show FORMULA or FORMAT of another cell
http://www.mvps.org/dmcritchie/excel...htm#HasFormula
instructions on my page getstarted.htm see yellow box at top of page


A function cannot change the formatting, or move cells around, it can
only return a value.

Have you take a look at Data, Subtotals..
which allows you to make totals more visible
http://www.datapigtechnologies.com/ExcelMain.htm
look for . Basics of Using Subtotals (it's a video)

http://www.mvps.org/dmcritchie/excel....htm#subtotals




---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DoriCAFL" wrote in message ...
I have a sheet with a column of numbers and there are groups that are added
to get a sum of that group. I want to transfer just the cell with the total
to the next column over. The "total" cells are the only cells that contain
formulas in the column - I can get it to find them but not move them. I have
tried IF/THEN functions but can't get figure out the wording for "if this
cell is a formula, copy the value into the next column".