Reoreder/Rearrange columns through Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change excel columns through macros 3
Rearranging and renumbering data in rows 3
how to group a row so i can organise data by diff fields 1
Rearrange data into other columns 9
table w/ some columns as drop down 1
putting a column of names into alphabetical order 1
How to use the "shell" command? 10
Inserting new columns past the last column 3

Back
Top