| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Freezing the data in a column and moving the calculations to the next column
don't copy the whole column, start with the cell below the headers.
-- Regards, Tom Ogilvy "Mervyn Thomas" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving Column data formula | Excel Worksheet Functions | |||
| Moving data from one column to another | Excel Discussion (Misc queries) | |||
| Moving data from multiple cells to one column | Excel Discussion (Misc queries) | |||
| moving data within a column | Excel Worksheet Functions | |||
| Moving XL Data over By one Column (*Same Row) | Excel Programming | |||
Linear Mode
