Thread: Freezing the data in a column and moving the calculations to the next column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mervyn Thomas Mervyn Thomas is offline
external usenet poster
  
Posts: 44
Default Freezing the data in a column and moving the calculations to the next column
I have a simple P&L by month with 12 months along the top.
I'm trying to figure out the VB code that would enable an operator to copy a
selected column - say the january column, copy the formulas only to the
february column and then paste-special-values in the original january
column. This works OK manually except the paste-special-formulas only
command also pastes the previous column headings as well!
Can anyone suggest how to do this?


Reply With QuoteReply With Quote