Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort by Group Header or by Group SubHeader
Hello,
I'm perplexed on how to go about solving a Sorting problem in code. I have a group of rows with data listed across the columns ie. Row 3, Employee Name, [Name Input], Sales Yr, Jan, Feb, Mar, ...etc,Total. Row 4, Employee Number, [Number Input], Sales Yr, Jan, Feb, Mar, ...etc, Total. Row 5, Employee Status, [Status Input], Sales Yr, Jan, Feb, Mar, ...etc, Total. Row 6, Other Info, [Info Input], Sales Yr, Jan, Feb, Mar, ...etc, Total. This segment of data gets repeated down the sheet for each employee. Is there a way to sort by choosing the [Name Input] or by [Number Input] and keep each segment together? Thanks so much, Aria :) *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pagebreaks after last department in a group, color header on first | Excel Programming | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
I can't select/edit objects. It says [Group] on the header bar. | Excel Discussion (Misc queries) | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Sort by group | New Users to Excel |