View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
beginner beginner is offline
external usenet poster
 
Posts: 2
Default macro to copy columns from one sheet to another sheet

I have over 120 columns on one sheet and I would like to copy and
paste every 3rd column onto another sheet. I started to "record"
macro, but was wondering if there was a way to write code for this?

so I have something like this:


x y z x y z ...
1
1
2
3
8
7,etc..


I would like to copy all of the "x" column values onto another sheet.
Any solutions?


Thanks!