Okies,

Thanks for that, BUT I put that rather badly about the original post of copy/paste. I already know how to do that.

The sheets I am copying from and then pasting to...it's a matter of the original sheet (called Worksheet) has data that the user enters that I need to copy to the new area down the column. The second sheet (called productivity) has a formula ie =Worksheet!C156 so that when anything is entered into Worksheet!C156 that it automatically enters it into the relevant cell in the Productivity sheet.

The problem I face is that I have to either manually type the formulas into 6 different columns in over 400 rows long, in the Productivity sheet, what I'm after is a faster way of entering the formula when the original data is ACROSS the cells in the Worksheets.

Can this be done?