Hi,

Can any please advise me of the macro code I need to do the following:-

(a) locate the cell and row in a worksheet that contains the text ‘Current Month’ (which will always be in row three) and then copy the whole columns data and then paste 'special values' back into the same column in order to remove the formulas that are currently there

(b) When (a) above has been done move the text ‘Current Month’ to the cell directly to its right one cell e.g. K3 to L3


Any assistance would be greatly appreciated


Many thanks in advance


Regads


Rob

N.B. Excel version 2007