Change Column Position by Input

[Jakhongir]

Hello guys!

I need a help with VBA code to chnger order of columns when I click using drop down list

I have data of 12 stores, with 12 columns, each column consisting of stocks for each stores. What I want is, I want to specify the columns (each time it is going to be different) to be in what columns the store has to be, then the VBA code should create another sheet and paste the data from main sheet, exactly I specified which store to be in what columns.

I really appreciate your help on this. Thanks)

 

[ACommandLineKindaGuy]

Your goal isn't clear to me--maybe show us an example?

 

[Jakhongir]

Yes sure!

Actually, what I need is a constructor that can change order of columns in another sheet

Example: I have a data;

Column A
Column A
Column A
Column A

 

[Jakhongir]

Yes sure!

Actually, what I need is a constructor that can change order of columns in another sheet

Example: I have a data;

Column F: Store 1
Column G: Store 2
Column H: Store 3
....................................
Column Q; Store 12

Then, in another sheet I will have Constructor (I will manually write Store names for each column) for Stores but this time in different columns, for instance:

Column F: Store 2
Column G: Store 6
Column H: Store 3
....................................
Column Q; Store 11

When I run the VBA code, It should copy the data from main source, and paste it under each Store