• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Arrange according header row using VBA?

omprakashnagar

New Member
I have a big options sheet, I want to arrange according header row using vba.

I arrange all sheet this type


Size color Finish Color (Header Row)

1. Size color Finish Color

2. Size color Finish Color

3. Size color Finish


If not match header then cell is blank.
 
I'm afraid your example is not very helpful as it lists the same thing for each line. Could you post a different example showing what you do/don't want?
 
Okay Dear,


Please check attachment sheet,


1. http://www.excelforum.com/excel-programming/826109-arrange-according-header-row-using-vba.html


2. http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/5362d40f-23f5-4aa6-a39b-bba9bfd48539/#5362d40f-23f5-4aa6-a39b-bba9bfd48539
 
Om


Firstly Cross-Posting is generally frowned upon in Forums as it can cause multiple people to waste time trying to solve a problem that has already been solved elsewhere


This is discussed in the 3 Sticky Posts at : http://chandoo.org/forums/

Which i encourage you to read.


When you say "Arrange" what do you mean?


Do you just want to sort the data?

If so select the whole table then use the Data, Sort button.


Thirdly, we cannot download the file from those locations unless we subscribe

Once again please read the Green Posts for instructions on how to upload a file.
 
Back
Top