View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DoriCAFL
 
Posts: n/a
Default 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".