Solved

Excel VBA Syntax (Column Copy Between Worksheets)

Posted on 2007-03-20
3
6,919 Views
Last Modified: 2013-12-26
Howdy

I have 12 worksheets, each with 11 columns of data that I need to transfer into 11 other worksheets, one collumn at a time.  The pseudocode below sort of shows what I'm trying to do, but I'm light on the syntax specifics involved with VBA.  

for h = 1 to 12
   for i = 1 to 11
      for j = 1 to worksheet(h).Coumn(i).#ofRows
         copy all values from worksheet(h).Column(i).Row(j).value to worksheet13.Column(i).Row(j).value
         ....
         ....
         copy all values from worksheet(h).Column(i).Row(j).value to worksheet23.Column(i).Row(j).value
      end
   end
end

My big question is whether or not it's possible to just move an entire column in one command or whether it's necessary to move each value at a time.  That would only save me a single FOR loop, but complexity is complexity....the less complex the algorithm, the happier the gods tend to be.  

Any help would be, as always, greatly appreciated.

Jason
0
Comment
Question by:cdromes
3 Comments
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 25 total points
ID: 18760491
Hi Jason,

It's possible to copy an entire column. Like this....

    Worksheets(h).Column(i).Copy worksheet13.Column(i)

Regards,

Wayne
0
 
LVL 10

Assisted Solution

by:Ray
Ray earned 25 total points
ID: 18763943
Jason,

Not directly an answer, but . . .

Anytime your are "light" on syntax, just create a macro.  Use the record a macro feature to do what you want, then look at the code that was created and use it/ change it as you see fit.  This single tip will get you MANY, MANY Miles of value!  (at least it has for me).

good luck!
0
 

Author Comment

by:cdromes
ID: 18764389
Thanks to both for the answers!

rlistenb, that's so simple and handy that it's genius.  GENIUS!  

Jason
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question