Solved

Excel VBA Syntax (Column Copy Between Worksheets)

Posted on 2007-03-20
3
6,916 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
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…

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now