Excel VBA Syntax (Column Copy Between Worksheets)
Posted on 2007-03-20
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
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.