software

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 quot;totalquot; 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 quot;if this
cell is a formula, copy the value into the next columnquot;.

Hi Don,

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

see Show FORMULA or FORMAT of another cell
www.mvps.org/dmcritchie/excel...htm#HasFormula
instructions on my page getstarted.htm see yellow box at top of pageA 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
www.datapigtechnologies.com/ExcelMain.htm
look for . Basics of Using Subtotals (it's a video)

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

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

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