LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default How do I paste alternative columns from one worksheet to another?

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i paste rows/columns avoiding hidden rows/columns perezli Excel Discussion (Misc queries) 1 January 30th 09 03:58 PM
How to paste to alternating columns? [email protected] Excel Discussion (Misc queries) 3 October 15th 08 07:07 PM
How to delete or copy alternative rows/columns at a time? Bhagavan Excel Discussion (Misc queries) 0 May 12th 08 07:31 PM
Paste selected columns from worksheet in a workbook to anotherworkbook Orimslala Excel Discussion (Misc queries) 1 April 4th 08 02:40 AM
how paste w/o put in columns? Ian Elliott Excel Discussion (Misc queries) 4 February 14th 07 04:56 PM


All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"