Hi All, I have Grouped Supplier data as below.
Supplier A Product A Class 1 Product B Class 1 Supplier B Product C Class3 Product A Class2 I need to sort the Groups ( Supplier A , Supplier B ..... so on) But when i sort using Data> Sort function Excel Sorts all the contents in the column. Is there any way to work this out through VB, Will Named Ranges work???? This list will be updated every month. Thanks in advance. Chetan --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
