how to copy a column to another sheet

When I try to copy (CTRL-C) a column from one sheet to another I get the first formula only. Most of the options for paste special are grayed out. Receiving cells formatted ‘numbers’ ‘general’. What I’m trying to do is have a running total in the new sheet. If there’s a macro out there, I’d happily use it.


Are you selecting the whole column or just the top cell before ctrl-c-ing? Most of the paste special options are grayed out unless you un-click the paste all box.