How do I paste alternative columns from one worksheet to another?

F

Felix

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
 
E

eksh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top