View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
eksh eksh is offline
external usenet poster
 
Posts: 32
Default How do I paste alternative columns from one worksheet to another?

you may try the following:
copy feb to a new sheet. highlight alternate column (B, D, F,...) and delete
the contents.
then select all feb sheet and paste special to mar sheet by choosing skip
blank.
To automated it for future use you may record a macro when doing this.

"Felix" wrote:

I have two identical worsheets with different data i.e one file for Feb and
one for March. How can I paste information from the February file to the
March file. I don't want to psate every column but just alternate columns i.e
everyother column without haveing to copy each column one by one. Is there a
easier way where I can do it in one.
For e.g I want to copy columnc A & C without copying the information in
Column B. Can I do it in one go without having to highlight column A first
paste it and then do it with column C