View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
May May is offline
external usenet poster
 
Posts: 15
Default Adding Columns, Then deleting old columns

I want to add 240 to each cell in Column A (Column A + 240). Then I want the
new data to be the new Column A.

Right now I did: added Column B. Formulated 'Sum of Column A + Column B =
Column C' So, I wanted to make Column C to replace Column A. And delete
Column B. But the data keeps pulling the formula.

Please help! Thank you!