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.