Reoreder/Rearrange columns through Macros

C

Chandrasekaran P

whether possible to reorder the columns while downloading datas in the
excel.Can any one suggest how to rearrange the columns through macro's or
soem other ways?
 
T

Toppers

A simple macro which could be modified to loop through an array(s) of
input-to-output columns

Sub CopyColumns()

' Copy columns from sheet2 to sheet3

Sheets("Sheet2").Activate
Columns(1).Copy Sheets("Sheet3").Columns(3)
Columns(2).Copy Sheets("Sheet3").Columns(1)

Application.CutCopyMode = False

End Sub

HTH
 
Y

yaling

Hello Toppers,


I have a company name list with thousands of companies. I have insert equal
blank rows between each two companies. I need the company name to copy
themselves in the following blank rows. Do you know how to do that? Any tips
will be highly appreciated.

Yaling
 
G

Gord Dibben

yaling

Please stop high-jacking threads with your new questions.

That is about 3 you have going at different spots.

All we do is duplicate each others efforts.

Stick to one thread.


Gord Dibben MS Excel MVP
 
Top