LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Group rows based on indention of string in a column

I am looking for a macro VB code to automatically group rows.

Example values from column A:
Row1: Training
Row2: Phase 1A + 1B
Row3: Architecture Overview
Row4: Training relevant AC components
Row5: System Setup
Row6: Setup enviornments
Row7: DEV
Row8: QA
Row9: PROD

This would result into the following groups:
Row 3+4 grouped into row 2
Row 2 grouped into row1
Row 7 - 9 grouped into row 6
Row 6 grouped into row 5

Would greatly appreciate if somebody implemented the same requirement
already....

Thanks,
Chris
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Group into rows by every change of Column A Jan[_3_] Excel Discussion (Misc queries) 2 June 3rd 08 09:35 PM
VBA Code to Group Rows Based on Cell Contents pliskers Excel Programming 0 July 9th 06 10:48 PM
VBA Code to Group Rows Based on Cell Contents Pliskers Excel Programming 0 July 9th 06 03:08 AM
format group of rows based on condition Aaron Excel Discussion (Misc queries) 0 January 10th 06 12:29 AM
how would i select a group of rows based on a column value Brian Walker Excel Programming 1 June 15th 04 02:31 AM


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"