how to copy a column to another sheet [closed]

asked 2012-09-23 23:37:50 +0200

SFPete gravatar image

updated 2013-10-21 22:09:44 +0200

manj_k gravatar image

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.

Thanks, SFPete

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-02-23 08:48:22.544998

Comments

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.

w_whalley gravatar imagew_whalley ( 2012-09-24 00:00:14 +0200 )edit