How to sort data in Xl by adding a row at top

[Arun Joshi]

Dear Sir,
How to sort data in Excel by adding a row at top ie sorting by row and not by column as is normally done?
A row has nine columns. eg
due date, s. no., bank, holder, amount, when given for renewal, renewed due date, renewed amount etc
Regards,
A V Joshi

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx

 

[Dave Peterson]

I'm not sure I understand, but you sort a row by:
selecting the row
Data|sort (xl2003 menus)
Click the options button on the bottom of that dialog
Choose "sort left to right"

But I don't think that this is what you want.

Maybe you wanted to sort the range by using that top row????

If you're using xl2003, you could apply an autofilter and the dropdowns in each
of those header cells has an option to sort by that field/column.

Or...

I like this technique from Debra Dalgleish's site:
http://contextures.com/xlSort02.html#Rectangles
Sort With Invisible Rectangles

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)