Freezing the data in a column and moving the calculations to the next column

  • Thread starter Thread starter Mervyn Thomas
  • Start date Start date
M

Mervyn Thomas

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?
 
don't copy the whole column, start with the cell below the headers.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to run all variable combinations in a calculation model and store result 6
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
please help me format this date to Month and Year 4
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Copy and Paste Formula from ActiveCell to cells in 13 columns priorto the active column 1
Find last column & copy/paste values 1
Using SumIF with an array 3
Set value of cell to calculation 1

Back
Top