Sorting from horizontal to vertical

[mambo84]

http://www.excelforum.com/images/smilies/frown.gif

Dear All

Need your help urgent. Am looking for a VBA or formula to do sorting from horizontal to vertical. Attached is a sample

Beside this, the process should ignore the yellow highlighted cell. There were thousand of Product category and branch.

Thanks in advance

[Leith Ross]

Hello mambo84,

1. Do you want a button on the worksheet to start the sort?
2. Will the data to excluded be highlighted in yellow on the original document?
3. If the data is not highlighted, how will the data to excluded be recognized?

[mambo84]

Hello mambo84,

1. Do you want a button on the worksheet to start the sort? Yes
2. Will the data to excluded be highlighted in yellow on the original document?The data highlighted is to be excluded from the list and not the other way round
3. If the data is not highlighted, how will the data to excluded be recognized? if the data is not highlighted, it must appear in horizontal list.

Hi Leith Ross , please see the reply

[Leith Ross]

Hello mambo84,

What reply are you referring to? You quoted my last post. That does not answer my questions.

[mambo84]

[*] Do you want a button on the worksheet to start the sort? Yes[*] Will the data to excluded be highlighted in yellow on the original document?The data highlighted is to be excluded from the list and not the other way round[*] If the data is not highlighted, how will the data to excluded be recognized? if the data is not highlighted, it must appear in horizontal list.

Sorry, reply as highlighted.

Thank you

[Leith Ross]

Hello mambo84,

Will the data be arranged in tables exactly as you have shown?
Will the tables start at "C2" and move to the right?
Will there ever be tables below the ones you have shown?

[mambo84]

Hello Leith Ross

will the data be arranged in tables exactly as you have shown?
Not necessary, but prefer i can edit in further

Will the tables start at "C2" and move to the right?
Yes

Will there ever be tables below the ones you have shown?
No, i just need the header

Thanks

[Leith Ross]

Hello mambo84,

Sorry for all the questions. The macro code depends on how the data is arranged.

Are the tables in the workbook you posted the same as the tables in the original workbook?

[mambo84]

Hello Leith Ross

Is alright. i'm glad when you help me.

Yes, same as the original workbook. But the horizontal list should be in another sheet.

regards

[Leith Ross]

Hello mambo84,

Okay, now I can start on coding the macro for you.

[Leith Ross]

Hello mambo84,

Okay, here is the macro. It works as you specified on the posted workbook. There is button on "Sheet2" that runs the macro. The data is starts in cells "A2:C2". If rhe worksheet names in your workbook are different you will need to change them in the macro. They are marked in bold. The attached workbook has the macro and the button added.

Please Login or Register  to view this content.