How do you move cells with a formula

[Guest]

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".

 

[David McRitchie]

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/formula.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/sumdata.htm#subtotals